asked on

i get sql error 1326 when connect to other computer

i install sql server on window 7 and now i want to connect it to other windows 7

i install sql server management studio with sql server on other pc
when i get connect i get error 1326

i enable tcp ip in my sql server
sql browsing service us running
enable sql porn 1433 on other pc

butt same error i get

please help me

David Johnson, CD

did you enable the port in the source pc firewall ? Did you enable tcpip

for login you have to enable pcname\username OR use mixed mode i.e. Sql Server Login (SA)

ajaymaster1558

ASKER

yes it enable

in server pc
Untitled.png

Dmitry G

It's not a C# question, it would be better to move the question to more appropriate section...

Anyway, try the following:
http://www.mssqltips.com/sqlservertip/2340/resolving-could-not-open-a-connection-to-sql-server-errors/

ASKER CERTIFIED SOLUTION

Kishan Zunjare

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ajaymaster1558

ASKER

i try this i lot
i give you all details what i did

my first computer name is server i install sql server 2008 on it and there is a database
name diamondmanager

now i install sqlserver 2008 managment stedio on other pc name pc1

when i open pc1's managment stedio and connect to server i get 1326 error

1)i enable tcpip on server
2)server is running
3)sql browser service is running
4)enable port in pc1

still get error 1326

ajaymaster1558

ASKER

i add porn in server 1433

and now i ger new error

sql error 18452 the login is from an untrusted domain and cannot be used with windows authentication

Narender Gakka

hi there, seems you are running these systems in workgroup, hence getting this error, try using the SQL Authentication and you shouldn't be getting sql error 18452