Tuesday, 20 March 2012

connect to a SQL Server Personal Edition! Please help

Hi All,
I have a SQL Server Personal Edition installed in a PC running Windows XP
Prof. I can be accessed using Query Analyzer perfectly using SQL Server
authentication. However, I am unable to access it from another computer
using Query Analyzer. That computer also runs Windows XP Prof. The Personal
Edition SQL server can be found but just cannot get it connected.
Following is the error message from Query Analyzer:-
Sever: Msg 17, Level 16, State 1
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not
exist or
access denied.
Please help!
LarryHi
Running XP SP2?
Firewall.
http://www.microsoft.com/sql/techin...faq.asp

Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Larry Cheung" <larry@.hohotech.com> wrote in message
news:#4CAtWfyEHA.1204@.TK2MSFTNGP10.phx.gbl...
> Hi All,
> I have a SQL Server Personal Edition installed in a PC running Windows XP
> Prof. I can be accessed using Query Analyzer perfectly using SQL Server
> authentication. However, I am unable to access it from another computer
> using Query Analyzer. That computer also runs Windows XP Prof. The
Personal
> Edition SQL server can be found but just cannot get it connected.
> Following is the error message from Query Analyzer:-
> Sever: Msg 17, Level 16, State 1
> [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does n
ot exist or
> access denied.
> Please help!
> Larry
>

No comments:

Post a Comment