Client utility asks for the Server Alias name, and the server name.
If the computer-name is Location1, and the SQL-Server instance
name = BOB, and say the ip-adress is 1.2.3.4
Then,
Server Alias Name would = Location1\BOB
Server Name would = 1.2.3.4\BOB
Is this correct?
Yes!
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Robert A. DiFrancesco" wrote:
> Client utility asks for the Server Alias name, and the server name.
> If the computer-name is Location1, and the SQL-Server instance
> name = BOB, and say the ip-adress is 1.2.3.4
> Then,
> Server Alias Name would = Location1\BOB
> Server Name would = 1.2.3.4\BOB
> Is this correct?
>
>
|||I am having trouble connecting:
server doesn't exist or access denied
ConnectionOpen (connect() )
I can connect via XP remote desktop to the public ip 207.x.x.x .
In doing so and checking tcp/ip properties, I see that the setting is NOT to
obtain an IP automatically, rather it is "use this ip address". And the
local address is 192.x.x.x
How does this effect my connection setup?
thank you,
bob
"Hilary Cotter" <hilaryk@.att.net> wrote in message
news:9F58DE4A-569D-4561-8252-DABFDE6AFC99@.microsoft.com...[vbcol=seagreen]
> Yes!
> --
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
>
> "Robert A. DiFrancesco" wrote:
instance[vbcol=seagreen]
Location1\BOB[vbcol=seagreen]
Showing posts with label utility. Show all posts
Showing posts with label utility. Show all posts
Friday, February 24, 2012
Thursday, February 16, 2012
Client Network Utility Service Pack
2 Questions:
1) I am getting back into SQL more than before, in my new job. I need to find the service pack installed on the clients who have the Client Network Utility installed. I do not remember how to do this.
2) Running 'Select @.@.VERSION' on the server returns 7.00.1063 but does not indicate the service pack. Does this still mean sp4 has been installed?
I'm trying to ensure we'll all up to date since our dual 700 procs are acting eratic...jumps between 10 - 95% or so.
Server info:
NT Server SP6
SQL 7.0
2GB Ram
2 procs @. 700Mhz
Roughly 80 network connections.
No other programs running on server except Antivirus.
Thank you!Yes - sp4 is installed. Also, antivirus can cause several issues with any application. When you say jumping from 10% to 95%, are you isolating the application that is causing this ?|||Originally posted by rnealejr
Yes - sp4 is installed. Also, antivirus can cause several issues with any application. When you say jumping from 10% to 95%, are you isolating the application that is causing this ?
Thanks for the reply! Based on the Perf Monitor, sqlservr.exe uses up most of the CPU. VNC is what I am using to connect to it to monitor it remotely, which does take up some of the CPU. There are only a couple other programs that will take up 1 or 2 of the CPU, but that doesn't even seem worthy of mentioning.
There is only one database that is about 4.5 GB large. It is essentially an out of the box CRM system database, not custom built.
I have read an online resource for using Performance Monitor which was very helpful, but I haven't been able to determine what exactly SQL is doing to cause it to spike.
There are no jobs running while I am monitoring the performance. Memory doesn't seem to be a problem at all, and my indexes appear to be fine.
Thanks again!|||I would trash vnc and install terminal services (the administrative mode /not application) to remotely connect to your sql server machine. vnc causes cpu spikes. rtvscan is an antivirus application that causes spikes as well. When it hits 95% what applications are consuming the resource (is it only sql) ?
1) I am getting back into SQL more than before, in my new job. I need to find the service pack installed on the clients who have the Client Network Utility installed. I do not remember how to do this.
2) Running 'Select @.@.VERSION' on the server returns 7.00.1063 but does not indicate the service pack. Does this still mean sp4 has been installed?
I'm trying to ensure we'll all up to date since our dual 700 procs are acting eratic...jumps between 10 - 95% or so.
Server info:
NT Server SP6
SQL 7.0
2GB Ram
2 procs @. 700Mhz
Roughly 80 network connections.
No other programs running on server except Antivirus.
Thank you!Yes - sp4 is installed. Also, antivirus can cause several issues with any application. When you say jumping from 10% to 95%, are you isolating the application that is causing this ?|||Originally posted by rnealejr
Yes - sp4 is installed. Also, antivirus can cause several issues with any application. When you say jumping from 10% to 95%, are you isolating the application that is causing this ?
Thanks for the reply! Based on the Perf Monitor, sqlservr.exe uses up most of the CPU. VNC is what I am using to connect to it to monitor it remotely, which does take up some of the CPU. There are only a couple other programs that will take up 1 or 2 of the CPU, but that doesn't even seem worthy of mentioning.
There is only one database that is about 4.5 GB large. It is essentially an out of the box CRM system database, not custom built.
I have read an online resource for using Performance Monitor which was very helpful, but I haven't been able to determine what exactly SQL is doing to cause it to spike.
There are no jobs running while I am monitoring the performance. Memory doesn't seem to be a problem at all, and my indexes appear to be fine.
Thanks again!|||I would trash vnc and install terminal services (the administrative mode /not application) to remotely connect to your sql server machine. vnc causes cpu spikes. rtvscan is an antivirus application that causes spikes as well. When it hits 95% what applications are consuming the resource (is it only sql) ?
Client Network Utility in 2005
Where can I find the "Client Network Utility" in SQL 2005?scott
You need Configuration Tools--SQL Server Surface Area Manager .
"scott" <sbailey@.mileslumber.com> wrote in message
news:OTE$Kj9bGHA.4932@.TK2MSFTNGP03.phx.gbl...
> Where can I find the "Client Network Utility" in SQL 2005?
>|||I think you mean Configuration Tools | SQL Server Configuration Manager
(SQL Native Client Configuration section).
*mike hodgson*
http://sqlnerd.blogspot.com
Uri Dimant wrote:
>scott
>You need Configuration Tools--SQL Server Surface Area Manager .
>
>
>
>"scott" <sbailey@.mileslumber.com> wrote in message
>news:OTE$Kj9bGHA.4932@.TK2MSFTNGP03.phx.gbl...
>
>
>|||Yep, thanks Mike
"Mike Hodgson" <e1minst3r@.gmail.com> wrote in message news:Ojd7AGAcGHA.636@.T
K2MSFTNGP05.phx.gbl...
I think you mean Configuration Tools | SQL Server Configuration Manager (SQL
Native Client Configuration section).
mike hodgson
http://sqlnerd.blogspot.com
Uri Dimant wrote:
scott
You need Configuration Tools--SQL Server Surface Area Manager .
"scott" <sbailey@.mileslumber.com> wrote in message
news:OTE$Kj9bGHA.4932@.TK2MSFTNGP03.phx.gbl...
Where can I find the "Client Network Utility" in SQL 2005?|||thanks for directions.
"Uri Dimant" <urid@.iscar.co.il> wrote in message news:%23bxxyWAcGHA.4892@.TK2
MSFTNGP02.phx.gbl...
Yep, thanks Mike
"Mike Hodgson" <e1minst3r@.gmail.com> wrote in message news:Ojd7AGAcGHA.636@.T
K2MSFTNGP05.phx.gbl...
I think you mean Configuration Tools | SQL Server Configuration Manager (SQL
Native Client Configuration section).
mike hodgson
http://sqlnerd.blogspot.com
Uri Dimant wrote:
scott
You need Configuration Tools--SQL Server Surface Area Manager .
"scott" <sbailey@.mileslumber.com> wrote in message
news:OTE$Kj9bGHA.4932@.TK2MSFTNGP03.phx.gbl...
Where can I find the "Client Network Utility" in SQL 2005?
You need Configuration Tools--SQL Server Surface Area Manager .
"scott" <sbailey@.mileslumber.com> wrote in message
news:OTE$Kj9bGHA.4932@.TK2MSFTNGP03.phx.gbl...
> Where can I find the "Client Network Utility" in SQL 2005?
>|||I think you mean Configuration Tools | SQL Server Configuration Manager
(SQL Native Client Configuration section).
*mike hodgson*
http://sqlnerd.blogspot.com
Uri Dimant wrote:
>scott
>You need Configuration Tools--SQL Server Surface Area Manager .
>
>
>
>"scott" <sbailey@.mileslumber.com> wrote in message
>news:OTE$Kj9bGHA.4932@.TK2MSFTNGP03.phx.gbl...
>
>
>|||Yep, thanks Mike
"Mike Hodgson" <e1minst3r@.gmail.com> wrote in message news:Ojd7AGAcGHA.636@.T
K2MSFTNGP05.phx.gbl...
I think you mean Configuration Tools | SQL Server Configuration Manager (SQL
Native Client Configuration section).
mike hodgson
http://sqlnerd.blogspot.com
Uri Dimant wrote:
scott
You need Configuration Tools--SQL Server Surface Area Manager .
"scott" <sbailey@.mileslumber.com> wrote in message
news:OTE$Kj9bGHA.4932@.TK2MSFTNGP03.phx.gbl...
Where can I find the "Client Network Utility" in SQL 2005?|||thanks for directions.
"Uri Dimant" <urid@.iscar.co.il> wrote in message news:%23bxxyWAcGHA.4892@.TK2
MSFTNGP02.phx.gbl...
Yep, thanks Mike
"Mike Hodgson" <e1minst3r@.gmail.com> wrote in message news:Ojd7AGAcGHA.636@.T
K2MSFTNGP05.phx.gbl...
I think you mean Configuration Tools | SQL Server Configuration Manager (SQL
Native Client Configuration section).
mike hodgson
http://sqlnerd.blogspot.com
Uri Dimant wrote:
scott
You need Configuration Tools--SQL Server Surface Area Manager .
"scott" <sbailey@.mileslumber.com> wrote in message
news:OTE$Kj9bGHA.4932@.TK2MSFTNGP03.phx.gbl...
Where can I find the "Client Network Utility" in SQL 2005?
Client Network Utility cannot create alias for VPN SQL server connection?
I am trying to connect two SQL servers in different non-trusted domains.
SQLServer11 in Domain A and SQLServer22 in domain B. This is through a VPN
connection. Domain A has the VPN server. On SQLServer22 I could ping
SQLServer11.mydomain.local at IP address 192.168.100.50. On SQLServer22 I
use the client network utility to create an alias for SQLServer11 as
follows:
Network Libraries: TCP/IP
Server name: 192.168.100.50
Port No: 1433
Server alias: SQLServer11
Then I registered the new SQLServer11 in enterprise manager. But I keep
getting the error message "SQL server does not exist or access
denied.ConnectionOpen(Connect())" .
Why is this so? And how can I rectify the problem'If you use ping -a <ip address> does it bring back the correct name for the
server? If you ping SQLServer11 does it return the proper ip address? If
you are using NT authentication to register then try SQL authentication..
Verify that it is using port 1433 and that SQL Server is actually listening
on TCP/IP.
Rand
This posting is provided "as is" with no warranties and confers no rights.
SQLServer11 in Domain A and SQLServer22 in domain B. This is through a VPN
connection. Domain A has the VPN server. On SQLServer22 I could ping
SQLServer11.mydomain.local at IP address 192.168.100.50. On SQLServer22 I
use the client network utility to create an alias for SQLServer11 as
follows:
Network Libraries: TCP/IP
Server name: 192.168.100.50
Port No: 1433
Server alias: SQLServer11
Then I registered the new SQLServer11 in enterprise manager. But I keep
getting the error message "SQL server does not exist or access
denied.ConnectionOpen(Connect())" .
Why is this so? And how can I rectify the problem'If you use ping -a <ip address> does it bring back the correct name for the
server? If you ping SQLServer11 does it return the proper ip address? If
you are using NT authentication to register then try SQL authentication..
Verify that it is using port 1433 and that SQL Server is actually listening
on TCP/IP.
Rand
This posting is provided "as is" with no warranties and confers no rights.
client network utility & server network utility - what's the difference?
I'm confused about this. If I need MSDE installed on a server and have 10
workstations accessing it AND I don't want to use port 1433, what's the
process I need to go through to make that work right. I've fumbled around
with it and am not sure I follow the process. It seems logical to me that I
would run the server one on the server, set the port and then run the client
one on the client and set it to match the server but I hvae a feelign that's
not the case. Especially because since I'm not installing MSDE on any of the
client machines there is no network utility installed (AFAIK).
I'm also confused as to how DISABLENETWORKPROTOCOLS fits into this part of
things (if at all).
Thanks,
Keith
Yes, your thought is very logical and workable if the client network utility
is installed on workstations, so that you can have apps on workstation know
whih port is used to communicate with SQL Server. Actually, if you to create
a ODBC DSN to SQL Server, the DSN configuration provides you a dialog to
specify network library to use (TCP, Named Pipe...) and port number (or
dynamically determined).
However, in most cases, you do not need to run the client network utiliy on
workstations. The port number can be specified in the applications'
ConnectionString (if the app is designed well, there should be someway to
configure its connectionString, i.e. the database connection information).
AS for DISABLENETWORKPROTOCOLS, it is an installtion parameter. if you do
not explicitly set it to 0 when you install MSDE, by default, the MSDE is
not accessible from other computer. If you want the MSDE being accessible by
other computer, you either set it to 0 at installation or you can enable
network access after installation.
"Keith G Hicks" <krh@.comcast.net> wrote in message
news:%23phBoIf9GHA.3620@.TK2MSFTNGP04.phx.gbl...
> I'm confused about this. If I need MSDE installed on a server and have 10
> workstations accessing it AND I don't want to use port 1433, what's the
> process I need to go through to make that work right. I've fumbled around
> with it and am not sure I follow the process. It seems logical to me that
> I
> would run the server one on the server, set the port and then run the
> client
> one on the client and set it to match the server but I hvae a feelign
> that's
> not the case. Especially because since I'm not installing MSDE on any of
> the
> client machines there is no network utility installed (AFAIK).
> I'm also confused as to how DISABLENETWORKPROTOCOLS fits into this part of
> things (if at all).
> Thanks,
> Keith
>
|||Just wondering if there's a clear answer to this - if
DISABLENETWORKPROTOCOLS is set to 0 for let's say an initial installation of
MSDE sp3 so that the server is accessible from other workstations, what
happens if I set DISABLENETWORKPROTOCOLS=1 for an upgrade to sp4? Will that
basically disable the networkability for the specified instance of MSDE from
that point forward, or is that only temporary for the installation process?
"Norman Yuan" <NotReal@.NotReal.not> wrote in message
news:%23v3k7Xf9GHA.3264@.TK2MSFTNGP04.phx.gbl...
> Yes, your thought is very logical and workable if the client network
> utility is installed on workstations, so that you can have apps on
> workstation know whih port is used to communicate with SQL Server.
> Actually, if you to create a ODBC DSN to SQL Server, the DSN configuration
> provides you a dialog to specify network library to use (TCP, Named
> Pipe...) and port number (or dynamically determined).
> However, in most cases, you do not need to run the client network utiliy
> on workstations. The port number can be specified in the applications'
> ConnectionString (if the app is designed well, there should be someway to
> configure its connectionString, i.e. the database connection information).
> AS for DISABLENETWORKPROTOCOLS, it is an installtion parameter. if you do
> not explicitly set it to 0 when you install MSDE, by default, the MSDE is
> not accessible from other computer. If you want the MSDE being accessible
> by other computer, you either set it to 0 at installation or you can
> enable network access after installation.
>
> "Keith G Hicks" <krh@.comcast.net> wrote in message
> news:%23phBoIf9GHA.3620@.TK2MSFTNGP04.phx.gbl...
>
|||hi Bill,
Bill Hicks wrote:
> Just wondering if there's a clear answer to this - if
> DISABLENETWORKPROTOCOLS is set to 0 for let's say an initial
> installation of MSDE sp3 so that the server is accessible from other
> workstations, what happens if I set DISABLENETWORKPROTOCOLS=1 for an
> upgrade to sp4? Will that basically disable the networkability for
> the specified instance of MSDE from that point forward, or is that
> only temporary for the installation process?
as per
http://msdn.microsoft.com/library/de...tsql_84xl.asp,
DISABLENETWORKPROTOCOLS=n
In SQL Server 2000 SP3 or later, specifies how the Installer configures the
network protocol support for the instance of the Desktop Engine being
installed or upgraded. n is an integer number, and should be set to either 0
or 1.
These are the behaviors of DISABLNETWORKPROTOCOLS in SP3a or later:
Value Specified for n Installing New Instance
1:
Upgrading Existing Instance: Instance is configured with all server
Net-Libraries disabled.
Installing New Instance: Instance is configured with all server
Net-Libraries disabled.
0:
Upgrading Existing Instance: The existing server Net-Library configuration
is retained.
Installing New Instance: Instance is configured with default server
Net-Libraries and addresses enabled.
Parameter not specified, or is any value other than 0 or 1:
Upgrading Existing Instance: The existing server Net-Library configuration
is retained.
Installing New Instance: Instance is configured with all server
Net-Libraries disabled.
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.bizhttp://italy.mvps.org
DbaMgr2k ver 0.20.0 - DbaMgr ver 0.64.0 and further SQL Tools
-- remove DMO to reply
workstations accessing it AND I don't want to use port 1433, what's the
process I need to go through to make that work right. I've fumbled around
with it and am not sure I follow the process. It seems logical to me that I
would run the server one on the server, set the port and then run the client
one on the client and set it to match the server but I hvae a feelign that's
not the case. Especially because since I'm not installing MSDE on any of the
client machines there is no network utility installed (AFAIK).
I'm also confused as to how DISABLENETWORKPROTOCOLS fits into this part of
things (if at all).
Thanks,
Keith
Yes, your thought is very logical and workable if the client network utility
is installed on workstations, so that you can have apps on workstation know
whih port is used to communicate with SQL Server. Actually, if you to create
a ODBC DSN to SQL Server, the DSN configuration provides you a dialog to
specify network library to use (TCP, Named Pipe...) and port number (or
dynamically determined).
However, in most cases, you do not need to run the client network utiliy on
workstations. The port number can be specified in the applications'
ConnectionString (if the app is designed well, there should be someway to
configure its connectionString, i.e. the database connection information).
AS for DISABLENETWORKPROTOCOLS, it is an installtion parameter. if you do
not explicitly set it to 0 when you install MSDE, by default, the MSDE is
not accessible from other computer. If you want the MSDE being accessible by
other computer, you either set it to 0 at installation or you can enable
network access after installation.
"Keith G Hicks" <krh@.comcast.net> wrote in message
news:%23phBoIf9GHA.3620@.TK2MSFTNGP04.phx.gbl...
> I'm confused about this. If I need MSDE installed on a server and have 10
> workstations accessing it AND I don't want to use port 1433, what's the
> process I need to go through to make that work right. I've fumbled around
> with it and am not sure I follow the process. It seems logical to me that
> I
> would run the server one on the server, set the port and then run the
> client
> one on the client and set it to match the server but I hvae a feelign
> that's
> not the case. Especially because since I'm not installing MSDE on any of
> the
> client machines there is no network utility installed (AFAIK).
> I'm also confused as to how DISABLENETWORKPROTOCOLS fits into this part of
> things (if at all).
> Thanks,
> Keith
>
|||Just wondering if there's a clear answer to this - if
DISABLENETWORKPROTOCOLS is set to 0 for let's say an initial installation of
MSDE sp3 so that the server is accessible from other workstations, what
happens if I set DISABLENETWORKPROTOCOLS=1 for an upgrade to sp4? Will that
basically disable the networkability for the specified instance of MSDE from
that point forward, or is that only temporary for the installation process?
"Norman Yuan" <NotReal@.NotReal.not> wrote in message
news:%23v3k7Xf9GHA.3264@.TK2MSFTNGP04.phx.gbl...
> Yes, your thought is very logical and workable if the client network
> utility is installed on workstations, so that you can have apps on
> workstation know whih port is used to communicate with SQL Server.
> Actually, if you to create a ODBC DSN to SQL Server, the DSN configuration
> provides you a dialog to specify network library to use (TCP, Named
> Pipe...) and port number (or dynamically determined).
> However, in most cases, you do not need to run the client network utiliy
> on workstations. The port number can be specified in the applications'
> ConnectionString (if the app is designed well, there should be someway to
> configure its connectionString, i.e. the database connection information).
> AS for DISABLENETWORKPROTOCOLS, it is an installtion parameter. if you do
> not explicitly set it to 0 when you install MSDE, by default, the MSDE is
> not accessible from other computer. If you want the MSDE being accessible
> by other computer, you either set it to 0 at installation or you can
> enable network access after installation.
>
> "Keith G Hicks" <krh@.comcast.net> wrote in message
> news:%23phBoIf9GHA.3620@.TK2MSFTNGP04.phx.gbl...
>
|||hi Bill,
Bill Hicks wrote:
> Just wondering if there's a clear answer to this - if
> DISABLENETWORKPROTOCOLS is set to 0 for let's say an initial
> installation of MSDE sp3 so that the server is accessible from other
> workstations, what happens if I set DISABLENETWORKPROTOCOLS=1 for an
> upgrade to sp4? Will that basically disable the networkability for
> the specified instance of MSDE from that point forward, or is that
> only temporary for the installation process?
as per
http://msdn.microsoft.com/library/de...tsql_84xl.asp,
DISABLENETWORKPROTOCOLS=n
In SQL Server 2000 SP3 or later, specifies how the Installer configures the
network protocol support for the instance of the Desktop Engine being
installed or upgraded. n is an integer number, and should be set to either 0
or 1.
These are the behaviors of DISABLNETWORKPROTOCOLS in SP3a or later:
Value Specified for n Installing New Instance
1:
Upgrading Existing Instance: Instance is configured with all server
Net-Libraries disabled.
Installing New Instance: Instance is configured with all server
Net-Libraries disabled.
0:
Upgrading Existing Instance: The existing server Net-Library configuration
is retained.
Installing New Instance: Instance is configured with default server
Net-Libraries and addresses enabled.
Parameter not specified, or is any value other than 0 or 1:
Upgrading Existing Instance: The existing server Net-Library configuration
is retained.
Installing New Instance: Instance is configured with all server
Net-Libraries disabled.
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.bizhttp://italy.mvps.org
DbaMgr2k ver 0.20.0 - DbaMgr ver 0.64.0 and further SQL Tools
-- remove DMO to reply
Client Network Utility - tcp/ip
what is the syntax the server alias and the server name?
Is this correct: server alias should be the
"computer-name\sql-instance-name"? Will it work against a default instance?
server name should be the "ip-address\instance name"?
You can use anything for a server alias. If you want to hide that fact that
an instance is an instance, you can just use a single word as the alias. Or
you could mask a default instance as a named instance. The server name can
be either the network (computer) name or the IP-address if you are using
TCP/IP, with the instance name added if necessary.
Jacco Schalkwijk
SQL Server MVP
"Robert A. DiFrancesco" <bob.difrancesco@.comcash.com> wrote in message
news:OeOF%23rPVFHA.3024@.TK2MSFTNGP14.phx.gbl...
> what is the syntax the server alias and the server name?
> Is this correct: server alias should be the
> "computer-name\sql-instance-name"? Will it work against a default
> instance?
> server name should be the "ip-address\instance
> name"?
>
Is this correct: server alias should be the
"computer-name\sql-instance-name"? Will it work against a default instance?
server name should be the "ip-address\instance name"?
You can use anything for a server alias. If you want to hide that fact that
an instance is an instance, you can just use a single word as the alias. Or
you could mask a default instance as a named instance. The server name can
be either the network (computer) name or the IP-address if you are using
TCP/IP, with the instance name added if necessary.
Jacco Schalkwijk
SQL Server MVP
"Robert A. DiFrancesco" <bob.difrancesco@.comcash.com> wrote in message
news:OeOF%23rPVFHA.3024@.TK2MSFTNGP14.phx.gbl...
> what is the syntax the server alias and the server name?
> Is this correct: server alias should be the
> "computer-name\sql-instance-name"? Will it work against a default
> instance?
> server name should be the "ip-address\instance
> name"?
>
Client Network Utility - tcp/ip
what is the syntax the server alias and the server name?
Is this correct: server alias should be the
"computer-name\sql-instance-name"? Will it work against a default instance?
server name should be the "ip-address\instance name"?You can use anything for a server alias. If you want to hide that fact that
an instance is an instance, you can just use a single word as the alias. Or
you could mask a default instance as a named instance. The server name can
be either the network (computer) name or the IP-address if you are using
TCP/IP, with the instance name added if necessary.
Jacco Schalkwijk
SQL Server MVP
"Robert A. DiFrancesco" <bob.difrancesco@.comcash.com> wrote in message
news:OeOF%23rPVFHA.3024@.TK2MSFTNGP14.phx.gbl...
> what is the syntax the server alias and the server name?
> Is this correct: server alias should be the
> "computer-name\sql-instance-name"? Will it work against a default
> instance?
> server name should be the "ip-address\instance
> name"?
>
Is this correct: server alias should be the
"computer-name\sql-instance-name"? Will it work against a default instance?
server name should be the "ip-address\instance name"?You can use anything for a server alias. If you want to hide that fact that
an instance is an instance, you can just use a single word as the alias. Or
you could mask a default instance as a named instance. The server name can
be either the network (computer) name or the IP-address if you are using
TCP/IP, with the instance name added if necessary.
Jacco Schalkwijk
SQL Server MVP
"Robert A. DiFrancesco" <bob.difrancesco@.comcash.com> wrote in message
news:OeOF%23rPVFHA.3024@.TK2MSFTNGP14.phx.gbl...
> what is the syntax the server alias and the server name?
> Is this correct: server alias should be the
> "computer-name\sql-instance-name"? Will it work against a default
> instance?
> server name should be the "ip-address\instance
> name"?
>
Client Network Utility
Guys,
Anybody knows how the client network utility can be configured PROGRAMATICALLY.
What I wanna do ultimately, is to run a batch file and set an alias for the client network utility.
Thanks,
Regards,Any possibilities thru OSQL? I haven't found anything yet.|||Double posting. :)|||I'm pretty sure that you can do it with a registry file... don't have SQL Server on my new laptop yet so I can't tell you what key, but it should be in HKEY_LOCAL_MACHINE somewhere
all you should have to do is set it up, do a search in the registry (using regedit) for the alias or whatever you added, export that key to a *.reg file, clean up the file a bit (to get rid of duplicate or extraneous keys) and import it on a test machine to check it out.
I use that method to add system ODBC data sources all the time, never done it with the Client Network Utility though... standard disclaimer however... if you mess up the registry it's your fault and don't forget to back it up before importing anything|||Hey thanx Drew. Interesting idea. I'll give it a try and let you know what happened.|||sure thing... I'll be in the office tomorrow and will post it up if I get to it before you, been meaning to do it for a long time to make client config as dummy proof as possible so I don't have to sit on the phone t-shooting stupid crap like that
Anybody knows how the client network utility can be configured PROGRAMATICALLY.
What I wanna do ultimately, is to run a batch file and set an alias for the client network utility.
Thanks,
Regards,Any possibilities thru OSQL? I haven't found anything yet.|||Double posting. :)|||I'm pretty sure that you can do it with a registry file... don't have SQL Server on my new laptop yet so I can't tell you what key, but it should be in HKEY_LOCAL_MACHINE somewhere
all you should have to do is set it up, do a search in the registry (using regedit) for the alias or whatever you added, export that key to a *.reg file, clean up the file a bit (to get rid of duplicate or extraneous keys) and import it on a test machine to check it out.
I use that method to add system ODBC data sources all the time, never done it with the Client Network Utility though... standard disclaimer however... if you mess up the registry it's your fault and don't forget to back it up before importing anything|||Hey thanx Drew. Interesting idea. I'll give it a try and let you know what happened.|||sure thing... I'll be in the office tomorrow and will post it up if I get to it before you, been meaning to do it for a long time to make client config as dummy proof as possible so I don't have to sit on the phone t-shooting stupid crap like that
Client Network Utility
Is it possible to create an alias under Client Network Utility
Programatically using SQL Server or MSDE
The problem I have is to install msde at a client and setup replication with
my main server.
I need the alais to inteprut the name into ip address for the replication to
work.
----
--
Robert Craill
Web Development
USP Designs (Pty) Ltd
E: robert@.cyberprop.com
T: +27 11 955 9100
F: +27 11 955 9110
W: www.cyberprop.com
W: www.cyberagent.co.za
W: www.cyberbonds.co.za
USP Designs (Pty) Ltd is Proudly South African!
This message and any attachments are confidential and intended solely for
the addressee. Any unauthorized use, alteration or dissemination is
prohibited. USP Designs (Pty) Ltd. accepts no liability whatsoever for any
loss, whether it be direct, indirect or consequential, arising from
information made available and actions resulting there from.The aliases are stored as registry keys under
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MS
SQLServer\Client\ConnectTo
Create them on a source machine, export the keys, and import/create them
during setup.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Robert Craill" <robert@.cyberprop.com> wrote in message
news:OMYk7P$zFHA.2652@.TK2MSFTNGP14.phx.gbl...
> Is it possible to create an alias under Client Network Utility
> Programatically using SQL Server or MSDE
> The problem I have is to install msde at a client and setup replication
> with my main server.
> I need the alais to inteprut the name into ip address for the replication
> to work.
>
> --
> ----
--
> Robert Craill
> Web Development
> USP Designs (Pty) Ltd
> E: robert@.cyberprop.com
> T: +27 11 955 9100
> F: +27 11 955 9110
> W: www.cyberprop.com
> W: www.cyberagent.co.za
> W: www.cyberbonds.co.za
> USP Designs (Pty) Ltd is Proudly South African!
> This message and any attachments are confidential and intended solely for
> the addressee. Any unauthorized use, alteration or dissemination is
> prohibited. USP Designs (Pty) Ltd. accepts no liability whatsoever for any
> loss, whether it be direct, indirect or consequential, arising from
> information made available and actions resulting there from.
>|||As Easy as That.
Thanks for saving me time .
*** Sent via Developersdex http://www.codecomments.com ***
Programatically using SQL Server or MSDE
The problem I have is to install msde at a client and setup replication with
my main server.
I need the alais to inteprut the name into ip address for the replication to
work.
----
--
Robert Craill
Web Development
USP Designs (Pty) Ltd
E: robert@.cyberprop.com
T: +27 11 955 9100
F: +27 11 955 9110
W: www.cyberprop.com
W: www.cyberagent.co.za
W: www.cyberbonds.co.za
USP Designs (Pty) Ltd is Proudly South African!
This message and any attachments are confidential and intended solely for
the addressee. Any unauthorized use, alteration or dissemination is
prohibited. USP Designs (Pty) Ltd. accepts no liability whatsoever for any
loss, whether it be direct, indirect or consequential, arising from
information made available and actions resulting there from.The aliases are stored as registry keys under
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MS
SQLServer\Client\ConnectTo
Create them on a source machine, export the keys, and import/create them
during setup.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Robert Craill" <robert@.cyberprop.com> wrote in message
news:OMYk7P$zFHA.2652@.TK2MSFTNGP14.phx.gbl...
> Is it possible to create an alias under Client Network Utility
> Programatically using SQL Server or MSDE
> The problem I have is to install msde at a client and setup replication
> with my main server.
> I need the alais to inteprut the name into ip address for the replication
> to work.
>
> --
> ----
--
> Robert Craill
> Web Development
> USP Designs (Pty) Ltd
> E: robert@.cyberprop.com
> T: +27 11 955 9100
> F: +27 11 955 9110
> W: www.cyberprop.com
> W: www.cyberagent.co.za
> W: www.cyberbonds.co.za
> USP Designs (Pty) Ltd is Proudly South African!
> This message and any attachments are confidential and intended solely for
> the addressee. Any unauthorized use, alteration or dissemination is
> prohibited. USP Designs (Pty) Ltd. accepts no liability whatsoever for any
> loss, whether it be direct, indirect or consequential, arising from
> information made available and actions resulting there from.
>|||As Easy as That.
Thanks for saving me time .
*** Sent via Developersdex http://www.codecomments.com ***
Client Network Utility
I have created a SQL2000 database on our server. I am trying to run the serv
ice using the Service Manager.
I have already created an alias using Client Network Utility - TCPIP.
But every time i select the service i get The network path is not found.
ANy ideas ?You really do not need the alias... So delete it ( to start).
Run client network utility and make sure that TCP IP is seleted onthe
client..
Begin by going to the server and starting sql
On the client
1. Go to the command prompt and try to ping the server
name
Then run Query analyzer and simply try to connect using a trusted connection
to the servername..
The most common reason you get the error which is 'the server is
unavailable or the network path not found.'
is that the server is not running.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"MarkWakelin" <anonymous@.discussions.microsoft.com> wrote in message
news:AC98DA96-60F6-4A05-9664-A94985536F67@.microsoft.com...
> I have created a SQL2000 database on our server. I am trying to run the
service using the Service Manager.
> I have already created an alias using Client Network Utility - TCPIP.
> But every time i select the service i get The network path is not found.
> ANy ideas ?|||The service is running on my server, and i have tried pinging the server fro
m my laptop, but still no luck !|||I received a reply from my server when i pinged it.
ice using the Service Manager.
I have already created an alias using Client Network Utility - TCPIP.
But every time i select the service i get The network path is not found.
ANy ideas ?You really do not need the alias... So delete it ( to start).
Run client network utility and make sure that TCP IP is seleted onthe
client..
Begin by going to the server and starting sql
On the client
1. Go to the command prompt and try to ping the server
name
Then run Query analyzer and simply try to connect using a trusted connection
to the servername..
The most common reason you get the error which is 'the server is
unavailable or the network path not found.'
is that the server is not running.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"MarkWakelin" <anonymous@.discussions.microsoft.com> wrote in message
news:AC98DA96-60F6-4A05-9664-A94985536F67@.microsoft.com...
> I have created a SQL2000 database on our server. I am trying to run the
service using the Service Manager.
> I have already created an alias using Client Network Utility - TCPIP.
> But every time i select the service i get The network path is not found.
> ANy ideas ?|||The service is running on my server, and i have tried pinging the server fro
m my laptop, but still no luck !|||I received a reply from my server when i pinged it.
Client Network Utility
Is it possible to create an alias under Client Network Utility
Programatically using SQL Server or MSDE
The problem I have is to install msde at a client and setup replication with
my main server.
I need the alais to inteprut the name into ip address for the replication to
work.
Robert Craill
Web Development
USP Designs (Pty) Ltd
E: robert@.cyberprop.com
T: +27 11 955 9100
F: +27 11 955 9110
W: www.cyberprop.com
W: www.cyberagent.co.za
W: www.cyberbonds.co.za
USP Designs (Pty) Ltd is Proudly South African!
This message and any attachments are confidential and intended solely for
the addressee. Any unauthorized use, alteration or dissemination is
prohibited. USP Designs (Pty) Ltd. accepts no liability whatsoever for any
loss, whether it be direct, indirect or consequential, arising from
information made available and actions resulting there from.
The aliases are stored as registry keys under
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\ Client\ConnectTo
Create them on a source machine, export the keys, and import/create them
during setup.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Robert Craill" <robert@.cyberprop.com> wrote in message
news:OMYk7P$zFHA.2652@.TK2MSFTNGP14.phx.gbl...
> Is it possible to create an alias under Client Network Utility
> Programatically using SQL Server or MSDE
> The problem I have is to install msde at a client and setup replication
> with my main server.
> I need the alais to inteprut the name into ip address for the replication
> to work.
>
> --
> ----
> Robert Craill
> Web Development
> USP Designs (Pty) Ltd
> E: robert@.cyberprop.com
> T: +27 11 955 9100
> F: +27 11 955 9110
> W: www.cyberprop.com
> W: www.cyberagent.co.za
> W: www.cyberbonds.co.za
> USP Designs (Pty) Ltd is Proudly South African!
> This message and any attachments are confidential and intended solely for
> the addressee. Any unauthorized use, alteration or dissemination is
> prohibited. USP Designs (Pty) Ltd. accepts no liability whatsoever for any
> loss, whether it be direct, indirect or consequential, arising from
> information made available and actions resulting there from.
>
|||As Easy as That.
Thanks for saving me time .
*** Sent via Developersdex http://www.codecomments.com ***
Programatically using SQL Server or MSDE
The problem I have is to install msde at a client and setup replication with
my main server.
I need the alais to inteprut the name into ip address for the replication to
work.
Robert Craill
Web Development
USP Designs (Pty) Ltd
E: robert@.cyberprop.com
T: +27 11 955 9100
F: +27 11 955 9110
W: www.cyberprop.com
W: www.cyberagent.co.za
W: www.cyberbonds.co.za
USP Designs (Pty) Ltd is Proudly South African!
This message and any attachments are confidential and intended solely for
the addressee. Any unauthorized use, alteration or dissemination is
prohibited. USP Designs (Pty) Ltd. accepts no liability whatsoever for any
loss, whether it be direct, indirect or consequential, arising from
information made available and actions resulting there from.
The aliases are stored as registry keys under
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\ Client\ConnectTo
Create them on a source machine, export the keys, and import/create them
during setup.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Robert Craill" <robert@.cyberprop.com> wrote in message
news:OMYk7P$zFHA.2652@.TK2MSFTNGP14.phx.gbl...
> Is it possible to create an alias under Client Network Utility
> Programatically using SQL Server or MSDE
> The problem I have is to install msde at a client and setup replication
> with my main server.
> I need the alais to inteprut the name into ip address for the replication
> to work.
>
> --
> ----
> Robert Craill
> Web Development
> USP Designs (Pty) Ltd
> E: robert@.cyberprop.com
> T: +27 11 955 9100
> F: +27 11 955 9110
> W: www.cyberprop.com
> W: www.cyberagent.co.za
> W: www.cyberbonds.co.za
> USP Designs (Pty) Ltd is Proudly South African!
> This message and any attachments are confidential and intended solely for
> the addressee. Any unauthorized use, alteration or dissemination is
> prohibited. USP Designs (Pty) Ltd. accepts no liability whatsoever for any
> loss, whether it be direct, indirect or consequential, arising from
> information made available and actions resulting there from.
>
|||As Easy as That.
Thanks for saving me time .
*** Sent via Developersdex http://www.codecomments.com ***
Client Network Utility
I have created a SQL2000 database on our server. I am trying to run the service using the Service Manager.
I have already created an alias using Client Network Utility - TCPIP.
But every time i select the service i get The network path is not found.
ANy ideas ?
You really do not need the alias... So delete it ( to start).
Run client network utility and make sure that TCP IP is seleted onthe
client..
Begin by going to the server and starting sql
On the client
1. Go to the command prompt and try to ping the server
name
Then run Query analyzer and simply try to connect using a trusted connection
to the servername..
The most common reason you get the error which is 'the server is
unavailable or the network path not found.'
is that the server is not running.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"MarkWakelin" <anonymous@.discussions.microsoft.com> wrote in message
news:AC98DA96-60F6-4A05-9664-A94985536F67@.microsoft.com...
> I have created a SQL2000 database on our server. I am trying to run the
service using the Service Manager.
> I have already created an alias using Client Network Utility - TCPIP.
> But every time i select the service i get The network path is not found.
> ANy ideas ?
|||The service is running on my server, and i have tried pinging the server from my laptop, but still no luck !
|||I received a reply from my server when i pinged it.
I have already created an alias using Client Network Utility - TCPIP.
But every time i select the service i get The network path is not found.
ANy ideas ?
You really do not need the alias... So delete it ( to start).
Run client network utility and make sure that TCP IP is seleted onthe
client..
Begin by going to the server and starting sql
On the client
1. Go to the command prompt and try to ping the server
name
Then run Query analyzer and simply try to connect using a trusted connection
to the servername..
The most common reason you get the error which is 'the server is
unavailable or the network path not found.'
is that the server is not running.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"MarkWakelin" <anonymous@.discussions.microsoft.com> wrote in message
news:AC98DA96-60F6-4A05-9664-A94985536F67@.microsoft.com...
> I have created a SQL2000 database on our server. I am trying to run the
service using the Service Manager.
> I have already created an alias using Client Network Utility - TCPIP.
> But every time i select the service i get The network path is not found.
> ANy ideas ?
|||The service is running on my server, and i have tried pinging the server from my laptop, but still no luck !
|||I received a reply from my server when i pinged it.
Client Network Utility
A third-party application we have to use requires the installation of the
Client Network Utility on clients workstation. Is there any way to install
this piece of the Client Tools without running through the standard SQL
Server setup routing that prompts for the CD-Key?
Thanks, in advance, for any assistance.
Brian Lorenz
You may already have it installed without knowing it...
Start | Run | cliconfg
<Enter>
Keith Kratochvil
"Lorenz, Brian" <LorenzBrian@.discussions.microsoft.com> wrote in message
news:F7D8D1F9-E914-409E-AA68-0A3DEED36457@.microsoft.com...
>A third-party application we have to use requires the installation of the
> Client Network Utility on clients workstation. Is there any way to install
> this piece of the Client Tools without running through the standard SQL
> Server setup routing that prompts for the CD-Key?
> Thanks, in advance, for any assistance.
> --
> Brian Lorenz
|||cliconfig not found.
I'm looking to install just the Client Network Utility on a bunch of clients
that have never had any of the SQL Client Tools installed...so, there's never
been any installation...I'm guessing that's why cliconfig is not present.
Brian Lorenz
"Keith Kratochvil" wrote:
> You may already have it installed without knowing it...
> Start | Run | cliconfg
> <Enter>
> --
> Keith Kratochvil
>
> "Lorenz, Brian" <LorenzBrian@.discussions.microsoft.com> wrote in message
> news:F7D8D1F9-E914-409E-AA68-0A3DEED36457@.microsoft.com...
>
>
|||Re-read my post. I typed cliconfg NOT cliconf_i_g
Keith Kratochvil
"Lorenz, Brian" <LorenzBrian@.discussions.microsoft.com> wrote in message
news:9BFB47F0-1155-4331-9F99-C3CF7FFA0B7F@.microsoft.com...[vbcol=seagreen]
> cliconfig not found.
> I'm looking to install just the Client Network Utility on a bunch of
> clients
> that have never had any of the SQL Client Tools installed...so, there's
> never
> been any installation...I'm guessing that's why cliconfig is not present.
> --
> Brian Lorenz
>
> "Keith Kratochvil" wrote:
Client Network Utility on clients workstation. Is there any way to install
this piece of the Client Tools without running through the standard SQL
Server setup routing that prompts for the CD-Key?
Thanks, in advance, for any assistance.
Brian Lorenz
You may already have it installed without knowing it...
Start | Run | cliconfg
<Enter>
Keith Kratochvil
"Lorenz, Brian" <LorenzBrian@.discussions.microsoft.com> wrote in message
news:F7D8D1F9-E914-409E-AA68-0A3DEED36457@.microsoft.com...
>A third-party application we have to use requires the installation of the
> Client Network Utility on clients workstation. Is there any way to install
> this piece of the Client Tools without running through the standard SQL
> Server setup routing that prompts for the CD-Key?
> Thanks, in advance, for any assistance.
> --
> Brian Lorenz
|||cliconfig not found.
I'm looking to install just the Client Network Utility on a bunch of clients
that have never had any of the SQL Client Tools installed...so, there's never
been any installation...I'm guessing that's why cliconfig is not present.
Brian Lorenz
"Keith Kratochvil" wrote:
> You may already have it installed without knowing it...
> Start | Run | cliconfg
> <Enter>
> --
> Keith Kratochvil
>
> "Lorenz, Brian" <LorenzBrian@.discussions.microsoft.com> wrote in message
> news:F7D8D1F9-E914-409E-AA68-0A3DEED36457@.microsoft.com...
>
>
|||Re-read my post. I typed cliconfg NOT cliconf_i_g
Keith Kratochvil
"Lorenz, Brian" <LorenzBrian@.discussions.microsoft.com> wrote in message
news:9BFB47F0-1155-4331-9F99-C3CF7FFA0B7F@.microsoft.com...[vbcol=seagreen]
> cliconfig not found.
> I'm looking to install just the Client Network Utility on a bunch of
> clients
> that have never had any of the SQL Client Tools installed...so, there's
> never
> been any installation...I'm guessing that's why cliconfig is not present.
> --
> Brian Lorenz
>
> "Keith Kratochvil" wrote:
Client Network Utility
Is it possible to create an alias under Client Network Utility
Programatically using SQL Server or MSDE
The problem I have is to install msde at a client and setup replication with
my main server.
I need the alais to inteprut the name into ip address for the replication to
work.
--
----
Robert Craill
Web Development
USP Designs (Pty) Ltd
E: robert@.cyberprop.com
T: +27 11 955 9100
F: +27 11 955 9110
W: www.cyberprop.com
W: www.cyberagent.co.za
W: www.cyberbonds.co.za
USP Designs (Pty) Ltd is Proudly South African!
This message and any attachments are confidential and intended solely for
the addressee. Any unauthorized use, alteration or dissemination is
prohibited. USP Designs (Pty) Ltd. accepts no liability whatsoever for any
loss, whether it be direct, indirect or consequential, arising from
information made available and actions resulting there from.The aliases are stored as registry keys under
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\ConnectTo
Create them on a source machine, export the keys, and import/create them
during setup.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Robert Craill" <robert@.cyberprop.com> wrote in message
news:OMYk7P$zFHA.2652@.TK2MSFTNGP14.phx.gbl...
> Is it possible to create an alias under Client Network Utility
> Programatically using SQL Server or MSDE
> The problem I have is to install msde at a client and setup replication
> with my main server.
> I need the alais to inteprut the name into ip address for the replication
> to work.
>
> --
> ----
> Robert Craill
> Web Development
> USP Designs (Pty) Ltd
> E: robert@.cyberprop.com
> T: +27 11 955 9100
> F: +27 11 955 9110
> W: www.cyberprop.com
> W: www.cyberagent.co.za
> W: www.cyberbonds.co.za
> USP Designs (Pty) Ltd is Proudly South African!
> This message and any attachments are confidential and intended solely for
> the addressee. Any unauthorized use, alteration or dissemination is
> prohibited. USP Designs (Pty) Ltd. accepts no liability whatsoever for any
> loss, whether it be direct, indirect or consequential, arising from
> information made available and actions resulting there from.
>
Programatically using SQL Server or MSDE
The problem I have is to install msde at a client and setup replication with
my main server.
I need the alais to inteprut the name into ip address for the replication to
work.
--
----
Robert Craill
Web Development
USP Designs (Pty) Ltd
E: robert@.cyberprop.com
T: +27 11 955 9100
F: +27 11 955 9110
W: www.cyberprop.com
W: www.cyberagent.co.za
W: www.cyberbonds.co.za
USP Designs (Pty) Ltd is Proudly South African!
This message and any attachments are confidential and intended solely for
the addressee. Any unauthorized use, alteration or dissemination is
prohibited. USP Designs (Pty) Ltd. accepts no liability whatsoever for any
loss, whether it be direct, indirect or consequential, arising from
information made available and actions resulting there from.The aliases are stored as registry keys under
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\ConnectTo
Create them on a source machine, export the keys, and import/create them
during setup.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Robert Craill" <robert@.cyberprop.com> wrote in message
news:OMYk7P$zFHA.2652@.TK2MSFTNGP14.phx.gbl...
> Is it possible to create an alias under Client Network Utility
> Programatically using SQL Server or MSDE
> The problem I have is to install msde at a client and setup replication
> with my main server.
> I need the alais to inteprut the name into ip address for the replication
> to work.
>
> --
> ----
> Robert Craill
> Web Development
> USP Designs (Pty) Ltd
> E: robert@.cyberprop.com
> T: +27 11 955 9100
> F: +27 11 955 9110
> W: www.cyberprop.com
> W: www.cyberagent.co.za
> W: www.cyberbonds.co.za
> USP Designs (Pty) Ltd is Proudly South African!
> This message and any attachments are confidential and intended solely for
> the addressee. Any unauthorized use, alteration or dissemination is
> prohibited. USP Designs (Pty) Ltd. accepts no liability whatsoever for any
> loss, whether it be direct, indirect or consequential, arising from
> information made available and actions resulting there from.
>
Client Network Utility
I have created a SQL2000 database on our server. I am trying to run the service using the Service Manager
I have already created an alias using Client Network Utility - TCPIP
But every time i select the service i get The network path is not found
ANy ideas ?You really do not need the alias... So delete it ( to start).
Run client network utility and make sure that TCP IP is seleted onthe
client..
Begin by going to the server and starting sql
On the client
1. Go to the command prompt and try to ping the server
name
Then run Query analyzer and simply try to connect using a trusted connection
to the servername..
The most common reason you get the error which is 'the server is
unavailable or the network path not found.'
is that the server is not running.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"MarkWakelin" <anonymous@.discussions.microsoft.com> wrote in message
news:AC98DA96-60F6-4A05-9664-A94985536F67@.microsoft.com...
> I have created a SQL2000 database on our server. I am trying to run the
service using the Service Manager.
> I have already created an alias using Client Network Utility - TCPIP.
> But every time i select the service i get The network path is not found.
> ANy ideas ?|||The service is running on my server, and i have tried pinging the server from my laptop, but still no luck|||I received a reply from my server when i pinged it
I have already created an alias using Client Network Utility - TCPIP
But every time i select the service i get The network path is not found
ANy ideas ?You really do not need the alias... So delete it ( to start).
Run client network utility and make sure that TCP IP is seleted onthe
client..
Begin by going to the server and starting sql
On the client
1. Go to the command prompt and try to ping the server
name
Then run Query analyzer and simply try to connect using a trusted connection
to the servername..
The most common reason you get the error which is 'the server is
unavailable or the network path not found.'
is that the server is not running.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"MarkWakelin" <anonymous@.discussions.microsoft.com> wrote in message
news:AC98DA96-60F6-4A05-9664-A94985536F67@.microsoft.com...
> I have created a SQL2000 database on our server. I am trying to run the
service using the Service Manager.
> I have already created an alias using Client Network Utility - TCPIP.
> But every time i select the service i get The network path is not found.
> ANy ideas ?|||The service is running on my server, and i have tried pinging the server from my laptop, but still no luck|||I received a reply from my server when i pinged it
Subscribe to:
Posts (Atom)