Hi,
I am handling a project where the client wants a client/server application which should run on local network. Now, in the development environment I am unable to connect to the Sql server from the other machine. Sql server is on the server machine(windows 7) where i tried to remove firewall and made static ip based network.
To connect to the database I used the connection string as below
connString="Server=xxx.xxx.xxx.xxx,1433;database=dbname;integrated security=true;user id='server machine name\administrator';password='server's administrator password';
This is working fine on the server machine. When I run the same application from the other machine itz posing an error:
Cannot login using 'server machine name\guest' account.
I used windows authentication on the server. Even, I enabled TCP/IP and provided the IP address of the Server Machine.
Can anyone please guide me with a good solution for this problem.
Thankyou.
I am handling a project where the client wants a client/server application which should run on local network. Now, in the development environment I am unable to connect to the Sql server from the other machine. Sql server is on the server machine(windows 7) where i tried to remove firewall and made static ip based network.
To connect to the database I used the connection string as below
connString="Server=xxx.xxx.xxx.xxx,1433;database=dbname;integrated security=true;user id='server machine name\administrator';password='server's administrator password';
This is working fine on the server machine. When I run the same application from the other machine itz posing an error:
Cannot login using 'server machine name\guest' account.
I used windows authentication on the server. Even, I enabled TCP/IP and provided the IP address of the Server Machine.
Can anyone please guide me with a good solution for this problem.
Thankyou.