Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
chander_2580
Yak Posting Veteran
76 Posts |
 Posted - 2008-01-06 : 14:33:11
|
| Hi Gurus our network team have change the name of the server and because of that i have to change the name of sqlserver 7.0, firstly after changing the computer name sqlserver got stopped... then i update the installation by runing the dump of sqlserver 7.0 std edition and the restart the server.Now i am unable to connect sqlserver by entering server ip in QA it gives me error as "[microsoft][ODBC sqlserver driver]cannot genrate SSPI context" i have also change the name of server by connecting by QA with the help of . (DOT) and runing the sp_dropserver'' and sp_addserver'' @local = 'local' sp's. please advice what to do .... thisis a production box.. please help methankschander |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-06 : 15:31:34
|
| You specified new host name in sp_addserver? Did you restart sql after running sp_addserver? |
 |
|
|
chander_2580
Yak Posting Veteran
76 Posts |
Posted - 2008-01-06 : 15:45:40
|
yes i do apecify new servername there in sp_addserver procedure.RegardsChanderquote:
Originally posted by rmiao
You specified new host name in sp_addserver? Did you restart sql after running sp_addserver?
|
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-06 : 17:53:34
|
| Then did you restart sql? New server name will not take effect otherwise. |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
|
|
|
|
|
Renameing sqlserver 7.0