server name woes

3 Aug 2006 7:06 PM

airwalker

I just got bought a used computer, and Im trying to change the server name,
I've changed the computer name and restarted the computer, I've also used
query analyser and changed the server name, but when I try run an c#
appication that connects to a sql database I get a server does not
exist/access denied error message.

when I go to enterprise manager and server service manager the server name
still comes up as PICARD\HOMESQL

obvuiusly I cant use a "\" in the connection string of my windows application.

does anybody know how I can change the server name to PETER.

thanks in advance

3 Aug 2006 9:39 PM

Ravi

It looks like PICARD is the old name of the computer and it has a named SQl
instance HOMESQL.
if you renamed the computer to PETER. The SQL must be refered as PETER\HOMESQL

Hope this helps

--
Thanks & Rate the Postings.
-Ravi-

Show quote

"airwalker" wrote:

> I just got bought a used computer, and Im trying to change the server name,
> I've changed the computer name and restarted the computer, I've also used
> query analyser and changed the server name, but when I try run an c#
> appication that connects to a sql database I get a server does not
> exist/access denied error message.
>
> when I go to enterprise manager and server service manager the server name
> still comes up as PICARD\HOMESQL
>
> obvuiusly I cant use a "\" in the connection string of my windows application.
>
> does anybody know how I can change the server name to PETER.
>
> thanks in advance
>

4 Aug 2006 6:44 AM

Omnibuzz

Hi,
I don't understand why you can't use '/' in your connection string..
moreover \HOMESQL is the instance name. Check out this link for changing the
server/instance name..
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_afterinstall_5r8f.asp

Hope this helps.

--
-Omnibuzz (The SQL GC)

http://omnibuzz-sql.blogspot.com/