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

Friday, March 23, 2012

How to alter server name?

Hi,
How to alter the server name after I install a SQL Server 2000. The SQL
Server name would be the computer name in default, however, I want to alter
the Server name different from computer name which the SQL Server reside in.Look up sp_dropserver and sp_addserver in BOL
HTH
--
Ray Higdon MCSE, MCDBA, CCNA
--
"Yelson Hwo" <hy5005@.hotmail.com> wrote in message
news:e0vxSWs6DHA.2524@.TK2MSFTNGP11.phx.gbl...
> Hi,
> How to alter the server name after I install a SQL Server 2000. The SQL
> Server name would be the computer name in default, however, I want to
alter
> the Server name different from computer name which the SQL Server reside
in.
>|||I have try this way, it does not work.
"Ray Higdon" <sqlhigdon@.nospam.yahoo.com> дÈëÓʼþ
news:OJYSmbs6DHA.2732@.TK2MSFTNGP09.phx.gbl...
> Look up sp_dropserver and sp_addserver in BOL
> HTH
> --
> Ray Higdon MCSE, MCDBA, CCNA
> --
> "Yelson Hwo" <hy5005@.hotmail.com> wrote in message
> news:e0vxSWs6DHA.2524@.TK2MSFTNGP11.phx.gbl...
> > Hi,
> > How to alter the server name after I install a SQL Server 2000. The SQL
> > Server name would be the computer name in default, however, I want to
> alter
> > the Server name different from computer name which the SQL Server reside
> in.
> >
> >
>|||What did you try? Can you provide the code?
--
Ray Higdon MCSE, MCDBA, CCNA
--
"Yelson Hwo" <hy5005@.hotmail.com> wrote in message
news:e41mZgs6DHA.3896@.TK2MSFTNGP11.phx.gbl...
> I have try this way, it does not work.
> "Ray Higdon" <sqlhigdon@.nospam.yahoo.com> дÈëÓʼþ
> news:OJYSmbs6DHA.2732@.TK2MSFTNGP09.phx.gbl...
> > Look up sp_dropserver and sp_addserver in BOL
> >
> > HTH
> >
> > --
> > Ray Higdon MCSE, MCDBA, CCNA
> > --
> > "Yelson Hwo" <hy5005@.hotmail.com> wrote in message
> > news:e0vxSWs6DHA.2524@.TK2MSFTNGP11.phx.gbl...
> > > Hi,
> > > How to alter the server name after I install a SQL Server 2000. The
SQL
> > > Server name would be the computer name in default, however, I want to
> > alter
> > > the Server name different from computer name which the SQL Server
reside
> > in.
> > >
> > >
> >
> >
>|||Hi:
Please read this KB article and it may be useful:
http://support.microsoft.com/default.aspx?scid=kb;en-us;303774
Best Wishes
Wei Ci Zhou|||I did as the below:
--
sp_dropserver 'old_name'
go
sp_addserver 'new_name', 'local'
go
--
now I restart the SQL Services, the @.@.servername change as the "new_name",
but acctually the SQL Server Name in work still is "old_name", if you try
use the "new_name" as the Server name, you can't establish a connection with
it, you can only establish a connection with the "old_name".
"Ray Higdon" <sqlhigdon@.nospam.yahoo.com>
news:uBVtRks6DHA.2576@.TK2MSFTNGP11.phx.gbl...
> What did you try? Can you provide the code?
> --
> Ray Higdon MCSE, MCDBA, CCNA
> --
> "Yelson Hwo" <hy5005@.hotmail.com> wrote in message
> news:e41mZgs6DHA.3896@.TK2MSFTNGP11.phx.gbl...
> > I have try this way, it does not work.
> > "Ray Higdon" <sqlhigdon@.nospam.yahoo.com> дÈëÓʼþ
> > news:OJYSmbs6DHA.2732@.TK2MSFTNGP09.phx.gbl...
> > > Look up sp_dropserver and sp_addserver in BOL
> > >
> > > HTH
> > >
> > > --
> > > Ray Higdon MCSE, MCDBA, CCNA
> > > --
> > > "Yelson Hwo" <hy5005@.hotmail.com> wrote in message
> > > news:e0vxSWs6DHA.2524@.TK2MSFTNGP11.phx.gbl...
> > > > Hi,
> > > > How to alter the server name after I install a SQL Server 2000. The
> SQL
> > > > Server name would be the computer name in default, however, I want
to
> > > alter
> > > > the Server name different from computer name which the SQL Server
> reside
> > > in.
> > > >
> > > >
> > >
> > >
> >
> >
>|||I didn't catch that was what you were trying to do, See if this link helps -
http://support.microsoft.com/default.aspx?scid=kb;en-us;289573
Ray Higdon MCSE, MCDBA, CCNA
--
"Yelson Hwo" <hy5005@.hotmail.com> wrote in message
news:uRvPr0s6DHA.2168@.TK2MSFTNGP12.phx.gbl...
> I did as the below:
> --
> sp_dropserver 'old_name'
> go
> sp_addserver 'new_name', 'local'
> go
> --
> now I restart the SQL Services, the @.@.servername change as the "new_name",
> but acctually the SQL Server Name in work still is "old_name", if you try
> use the "new_name" as the Server name, you can't establish a connection
with
> it, you can only establish a connection with the "old_name".
> "Ray Higdon" <sqlhigdon@.nospam.yahoo.com>
> news:uBVtRks6DHA.2576@.TK2MSFTNGP11.phx.gbl...
> > What did you try? Can you provide the code?
> >
> > --
> > Ray Higdon MCSE, MCDBA, CCNA
> > --
> > "Yelson Hwo" <hy5005@.hotmail.com> wrote in message
> > news:e41mZgs6DHA.3896@.TK2MSFTNGP11.phx.gbl...
> > > I have try this way, it does not work.
> > > "Ray Higdon" <sqlhigdon@.nospam.yahoo.com> дÈëÓʼþ
> > > news:OJYSmbs6DHA.2732@.TK2MSFTNGP09.phx.gbl...
> > > > Look up sp_dropserver and sp_addserver in BOL
> > > >
> > > > HTH
> > > >
> > > > --
> > > > Ray Higdon MCSE, MCDBA, CCNA
> > > > --
> > > > "Yelson Hwo" <hy5005@.hotmail.com> wrote in message
> > > > news:e0vxSWs6DHA.2524@.TK2MSFTNGP11.phx.gbl...
> > > > > Hi,
> > > > > How to alter the server name after I install a SQL Server 2000.
The
> > SQL
> > > > > Server name would be the computer name in default, however, I want
> to
> > > > alter
> > > > > the Server name different from computer name which the SQL Server
> > reside
> > > > in.
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>|||Seems like you didn't rename the machine in Windows?
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Yelson Hwo" <hy5005@.hotmail.com> wrote in message news:uRvPr0s6DHA.2168@.TK2MSFTNGP12.phx.gbl...
> I did as the below:
> --
> sp_dropserver 'old_name'
> go
> sp_addserver 'new_name', 'local'
> go
> --
> now I restart the SQL Services, the @.@.servername change as the "new_name",
> but acctually the SQL Server Name in work still is "old_name", if you try
> use the "new_name" as the Server name, you can't establish a connection with
> it, you can only establish a connection with the "old_name".
> "Ray Higdon" <sqlhigdon@.nospam.yahoo.com>
> news:uBVtRks6DHA.2576@.TK2MSFTNGP11.phx.gbl...
> > What did you try? Can you provide the code?
> >
> > --
> > Ray Higdon MCSE, MCDBA, CCNA
> > --
> > "Yelson Hwo" <hy5005@.hotmail.com> wrote in message
> > news:e41mZgs6DHA.3896@.TK2MSFTNGP11.phx.gbl...
> > > I have try this way, it does not work.
> > > "Ray Higdon" <sqlhigdon@.nospam.yahoo.com> дÈëÓʼþ
> > > news:OJYSmbs6DHA.2732@.TK2MSFTNGP09.phx.gbl...
> > > > Look up sp_dropserver and sp_addserver in BOL
> > > >
> > > > HTH
> > > >
> > > > --
> > > > Ray Higdon MCSE, MCDBA, CCNA
> > > > --
> > > > "Yelson Hwo" <hy5005@.hotmail.com> wrote in message
> > > > news:e0vxSWs6DHA.2524@.TK2MSFTNGP11.phx.gbl...
> > > > > Hi,
> > > > > How to alter the server name after I install a SQL Server 2000. The
> > SQL
> > > > > Server name would be the computer name in default, however, I want
> to
> > > > alter
> > > > > the Server name different from computer name which the SQL Server
> > reside
> > > > in.
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>sql

How to alter server name?

Hi,
How to alter the server name after I install a SQL Server 2000. The SQL
Server name would be the computer name in default, however, I want to alter
the Server name different from computer name which the SQL Server reside in.Look up sp_dropserver and sp_addserver in BOL
HTH
Ray Higdon MCSE, MCDBA, CCNA
--
"Yelson Hwo" <hy5005@.hotmail.com> wrote in message
news:e0vxSWs6DHA.2524@.TK2MSFTNGP11.phx.gbl...
quote:

> Hi,
> How to alter the server name after I install a SQL Server 2000. The SQL
> Server name would be the computer name in default, however, I want to

alter
quote:

> the Server name different from computer name which the SQL Server reside

in.
quote:

>
|||I have try this way, it does not work.
"Ray Higdon" <sqlhigdon@.nospam.yahoo.com> д?
news:OJYSmbs6DHA.2732@.TK2MSFTNGP09.phx.gbl...
quote:

> Look up sp_dropserver and sp_addserver in BOL
> HTH
> --
> Ray Higdon MCSE, MCDBA, CCNA
> --
> "Yelson Hwo" <hy5005@.hotmail.com> wrote in message
> news:e0vxSWs6DHA.2524@.TK2MSFTNGP11.phx.gbl...
> alter
> in.
>
|||What did you try? Can you provide the code?
Ray Higdon MCSE, MCDBA, CCNA
--
"Yelson Hwo" <hy5005@.hotmail.com> wrote in message
news:e41mZgs6DHA.3896@.TK2MSFTNGP11.phx.gbl...
quote:

> I have try this way, it does not work.
> "Ray Higdon" <sqlhigdon@.nospam.yahoo.com> д?
> news:OJYSmbs6DHA.2732@.TK2MSFTNGP09.phx.gbl...
SQL[QUOTE]
reside[QUOTE]
>
|||Hi:
Please read this KB article and it may be useful:
http://support.microsoft.com/defaul...kb;en-us;303774
Best Wishes
Wei Ci Zhou|||I did as the below:
--
sp_dropserver 'old_name'
go
sp_addserver 'new_name', 'local'
go
--
now I restart the SQL Services, the @.@.servername change as the "new_name",
but acctually the SQL Server Name in work still is "old_name", if you try
use the "new_name" as the Server name, you can't establish a connection with
it, you can only establish a connection with the "old_name".
"Ray Higdon" <sqlhigdon@.nospam.yahoo.com>
news:uBVtRks6DHA.2576@.TK2MSFTNGP11.phx.gbl...
quote:

> What did you try? Can you provide the code?
> --
> Ray Higdon MCSE, MCDBA, CCNA
> --
> "Yelson Hwo" <hy5005@.hotmail.com> wrote in message
> news:e41mZgs6DHA.3896@.TK2MSFTNGP11.phx.gbl...
> SQL
to[QUOTE]
> reside
>
|||I didn't catch that was what you were trying to do, See if this link helps -
http://support.microsoft.com/defaul...kb;en-us;289573
Ray Higdon MCSE, MCDBA, CCNA
--
"Yelson Hwo" <hy5005@.hotmail.com> wrote in message
news:uRvPr0s6DHA.2168@.TK2MSFTNGP12.phx.gbl...
quote:

> I did as the below:
> --
> sp_dropserver 'old_name'
> go
> sp_addserver 'new_name', 'local'
> go
> --
> now I restart the SQL Services, the @.@.servername change as the "new_name",
> but acctually the SQL Server Name in work still is "old_name", if you try
> use the "new_name" as the Server name, you can't establish a connection

with
quote:

> it, you can only establish a connection with the "old_name".
> "Ray Higdon" <sqlhigdon@.nospam.yahoo.com>
> news:uBVtRks6DHA.2576@.TK2MSFTNGP11.phx.gbl...
The[QUOTE]
> to
>
|||Seems like you didn't rename the machine in Windows?
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=...ls
erver
"Yelson Hwo" <hy5005@.hotmail.com> wrote in message news:uRvPr0s6DHA.2168@.TK2MSFTNGP12.phx.gbl...[Q
UOTE]
> I did as the below:
> --
> sp_dropserver 'old_name'
> go
> sp_addserver 'new_name', 'local'
> go
> --
> now I restart the SQL Services, the @.@.servername change as the "new_name",
> but acctually the SQL Server Name in work still is "old_name", if you try
> use the "new_name" as the Server name, you can't establish a connection wi
th
> it, you can only establish a connection with the "old_name".
> "Ray Higdon" <sqlhigdon@.nospam.yahoo.com>
> news:uBVtRks6DHA.2576@.TK2MSFTNGP11.phx.gbl...
> to
>[/QUOTE]

Monday, March 12, 2012

how to add ODBC DSN to multiple computers

Hello. I need to set add an SQL ODBC System DSN to each computer on
our domain.
The suggestions I've seen so far involve setting up a GPO startup
script using VBScript to call an API, or a batch file using odbcconf.
I don't know VB, and I could find very little information about how to
use odbcconf.
I would appreciate it if someone could give me a standard solution, if
there is one. I'm a little new to this, so I wouldn't be surprised if
I were completely off the mark.
thanks,
joseph
If the use of a DSN is not really mandatory for your application, then using
a DSN-Less ODBC connection might be an easier solution.
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF
"Joseph O'Brien" <obrien1984@.hotmail.com> wrote in message
news:1139438690.109709.324280@.g47g2000cwa.googlegr oups.com...
> Hello. I need to set add an SQL ODBC System DSN to each computer on
> our domain.
> The suggestions I've seen so far involve setting up a GPO startup
> script using VBScript to call an API, or a batch file using odbcconf.
> I don't know VB, and I could find very little information about how to
> use odbcconf.
> I would appreciate it if someone could give me a standard solution, if
> there is one. I'm a little new to this, so I wouldn't be surprised if
> I were completely off the mark.
> thanks,
> joseph
>

how to add ODBC DSN to multiple computers

Hello. I need to set add an SQL ODBC System DSN to each computer on
our domain.
The suggestions I've seen so far involve setting up a GPO startup
script using VBScript to call an API, or a batch file using odbcconf.
I don't know VB, and I could find very little information about how to
use odbcconf.
I would appreciate it if someone could give me a standard solution, if
there is one. I'm a little new to this, so I wouldn't be surprised if
I were completely off the mark.
thanks,
josephIf the use of a DSN is not really mandatory for your application, then using
a DSN-Less ODBC connection might be an easier solution.
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF
"Joseph O'Brien" <obrien1984@.hotmail.com> wrote in message
news:1139438690.109709.324280@.g47g2000cwa.googlegroups.com...
> Hello. I need to set add an SQL ODBC System DSN to each computer on
> our domain.
> The suggestions I've seen so far involve setting up a GPO startup
> script using VBScript to call an API, or a batch file using odbcconf.
> I don't know VB, and I could find very little information about how to
> use odbcconf.
> I would appreciate it if someone could give me a standard solution, if
> there is one. I'm a little new to this, so I wouldn't be surprised if
> I were completely off the mark.
> thanks,
> joseph
>

Sunday, February 19, 2012

how to access sql server express from other computer on the netwrok

Hi experts

I use a sqlserver on a local computer. i want to access the sqlserver from other computers on the network using the VWD. When trying to connect to the database i get the error:

"An error has occured while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)"

I enabled the TCP/IP and the Named Pipes protocols on the server and still the same error.

Thanks

check windows firewall enbale or not..

if yes, then let sql 2005 port pass through

|||

I just found the sollution.

1. when accessing from other computers, the servers 'Guest' account is used, so this accoun should have the correct permissions (not recommended) or access using another privileged acount

2. enable remote connection in the "SQL Serve surface area Configuration" tool

Thanks for the attention anyway