Unable to connect to SQL Server Personal Edition

I'm trying to connect to a local SQL Server 2000 'Personal Edition'
running on Windows XP Professional. I've tried everything, and
searched the forums for similar problems, but I can't get the
connection to work... :(

Using jdbc, with the follwing URL

jdbc:microsoft:sqlserver://localhost:1433;databaseName=mydb;

I call:

DriverManager.getConnection(url, userName, password)

and I get the following:

jdbc:microsoft:sqlserver://GS-DELL:1433;databaseName=gpldb;
SQLState: 08001
code: 0
Error establishing socket.
Connection refused: connect
Error establishing socket.

I've also tried using ADO but I 'Login refused: Not associated with a
trusted connection'

However, Query Analyzer connects just fine, and I can even use ISQL
with no problem from a DOS command prompt!!

I have set Mixed Authentication (SQL Server and Windows) for the
server, and I've confirmed my user/psw about 6 times (Query Analyzer
has no problem accessing the database...)

Please help! Any suggestions???

Are there some restrictions with SQl Server Personal Edition on XP???

Posted Via Usenet.com Premium Usenet Newsgroup Services
----------------------------------------------------------
** SPEED ** RETENTION ** COMPLETION ** ANONYMITY **
----------------------------------------------------------
http://www.usenet.com
.

Relevant Pages

  • Re: Slow booting xp home.
    ... Changing the boot order to boot first from your hard disk might save you a half second, but you won't be able to boot from a CD until you change it back - and the time spent to do that will erase any previous time saved. ... 2- Consider what software you really want to start with Windows and also how you've configured your applications at startup ... Installing and Registering Visual Studio Express Editions Smart Device ...
    (microsoft.public.windowsxp.perform_maintain)
  • Re: Bizzare SQL Network Error
    ... The bizzare thing is that, the same connection string, the same code to ... In a windows APP it works fine, in a Web APP I get ... >>I am trying to connect to a default instance of SQL Server 2000 Enterprise ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Problems Using Laptop As SQL Server - Log On Failed
    ... > connected to the network and no password for windows. ... > the name of the laptop as name of the SQL Server. ... > trusted SQL Server connection ... you have to change the authentication mode... ...
    (microsoft.public.sqlserver.msde)
  • Re: No Windows, Only SQL Server Authentication
    ... To establish a Windows authenticated connection from OSQL, ... SQL Server programatically. ... Your connection string needs to specify the type of authentication desired. ...
    (microsoft.public.sqlserver.security)
  • Re: Slow booting xp home.
    ... Thirty seconds to boot Windows? ... I read somewhere that Microsoft suggest 30s boot up on xp home, I have seen videos on youtube of 8s boot up on xp, I'd be delighted with 30s and happy just to get below a minute. ... Installing and Registering Visual Studio Express Editions Smart Device ...
    (microsoft.public.windowsxp.perform_maintain)
Quantcast