Re: new to sql and need some help. connectivity problems.
From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 06/05/04
- Next message: Tibor Karaszi: "Re: T-SQL query as parameter in SP"
- Previous message: Sunil: "T-SQL query as parameter in SP"
- In reply to: dave: "new to sql and need some help. connectivity problems."
- Messages sorted by: [ date ] [ thread ]
Date: Sat, 5 Jun 2004 09:39:36 +0200
Did you install SQL Server or MSDE? Basically, on the client, you use SQL Server's "Client Network Utility"
and on the server, you use "Server Network Utility" to configure the connectivity. If you have MSDE, it
doesn't have network access turned on by default, and you won't have an icon for SNU, but it is there and the
name of the exe file is: svrnetcn.exe.
-- Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://www.solidqualitylearning.com/ "dave" <anonymous@discussions.microsoft.com> wrote in message news:1AFB725A-1AF3-47BC-808B-198916327FCA@microsoft.com... > hi guys > > i've installed sql on a dedicated box for the purpose of using it for mom and sms but the only problem is when i go to install sms or mom on the other boxes it doesnt see the sql server. however if i start the mom setup process on the sql box it sees the sql sever. > > i have installed the client tools on both the sms and mom boxes and configured them point to the sql server over tcp/ip and the named pipe but to no avail. i also added a data source to the odbc console thinking that may help but no it didnt. > > what i've done so far > installed sql with integrated windows authentication > added it to ad > got the Microsoft SQL Server 2000 Books Online from the ms site > gone and purchased the ms sql server 2000 administration guide > started to read both books and am now scared of sql server 2000 > > are there some connectivity tools that would help in troubleshooting this or am i barking up the wrong tree? > > i have used sms and mom extensively before but this is my first attempt at sql. > > cheers > > d
- Next message: Tibor Karaszi: "Re: T-SQL query as parameter in SP"
- Previous message: Sunil: "T-SQL query as parameter in SP"
- In reply to: dave: "new to sql and need some help. connectivity problems."
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
