Connection refused in SQL Server 2005


i have installed sql server 2005 developer edition, , still have sql server 7 running on port 1433.

i have many sql7 databases connected cf7.0.2

when try connect new database can read , write in sql2005, connection refused error.

i'm not sure port connect sql2005 port shows 0 apparently means dynamic port allocation.

when try port 1434 connection refused.

i have user name set sa (and enabled in sql2005) , no password (windows authentication). same result if user name blank.

anyone got idea these settings should be?

doug

i have switched off dynamic port allocation , changed port 1435 , think connect sql server 2005, error:

the user not associated trusted sql server connection.

i have tried using sa , tried setting user name, cannot past error.

any appreciated.

doug


More discussions in Database Access


adobe

Comments

Popular posts from this blog

Thread: PKI Client 5.00 install (for eToken Pro)

ATmega2560-Arduino Pin Mapping

Crossfader Arduino Tutorial