Showing posts with label computer. Show all posts
Showing posts with label computer. Show all posts

Monday, March 19, 2012

change connectionstring for dataset

hi,

I'm having this application using the express way to create the dategridview by having the query string builder. However, my computer recently crashed and I have no idea to change the connection string. so when I load the whole windows application, I am unable to view the information that are supposed to be in the datagridview. however, it returned an exception.

after finding out the main culprit, I realised that the database is using the old sql server's login. since it is using the old database's login, therefore it is unable to log the information into the datagrid view.

Please help! Thanks.

I'm sorry to hear that your computer crashed. Did you mean to change connection strings for typed DataSet which you created via "Data Source Configuration Wizard"? If so, you only need to change the corresponding Data Connection in the Server Explorer, as all Typed DataSet generated by the wizard use connectionstrings defined in Data Connections. If you want to configure connection string for individual TableAdapter, you need to open the typed DataSet in Design view, and right click on the TableAdapter->choose Configure...->press Previous button untill you rearch the "Choose Your Data Connection" step.

Hope this helps.

|||

thanks for the guide..I'll try and see if it works in other computer..

Cheers,

Joelle

Sunday, March 11, 2012

change computer name?

hi,
I want to change the computer name. After that, the SQL server will still
work? If not, how to change the SQL Server Name?
Thanks..Yilue,
See
http://www.tkdinesh.com/faq/ans/rename.html
If this is a SQL2000, you need to change the originating_server column in
msdb..sysjobs table.Details here:
PRB: Error 14274 Occurs When You Update a SQL Agent Job After Renaming
Windows Server
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q281642
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"Y" <yilue7490@.rogers.com> wrote in message
news:%23oIilnabDHA.2308@.TK2MSFTNGP12.phx.gbl...
> hi,
> I want to change the computer name. After that, the SQL server will still
> work? If not, how to change the SQL Server Name?
> Thanks..
>

Change computer name while running SQL Server

I need to change the computer name on my Windows Server 2003. I am currently
running SQl Server, and I am trying to find out if changing the name will
affect the SQL server or not. Is there a process for doing this, or if I
change the name and reboot, will the name automatically change in the SQL
Server Services Manager?
Thanks,
JOE
"Joe Michl" <JoeMichl@.discussions.microsoft.com> wrote in message
news:094A1C97-34EE-49F2-B374-1BC7DF62A712@.microsoft.com...
> I need to change the computer name on my Windows Server 2003. I am
currently
> running SQl Server, and I am trying to find out if changing the name will
> affect the SQL server or not. Is there a process for doing this, or if I
> change the name and reboot, will the name automatically change in the SQL
> Server Services Manager?
As long as there are no applications coded for your specific server name you
should be OK. After changing the server name and rebooting, use the commands
in the following article:
http://support.microsoft.com/default...&Product=sql2k
Steve