Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Regarding accessing sql server on client machine

Author  Topic 

manisha.vk
Starting Member

17 Posts

Posted - 2011-09-14 : 02:20:53
[Hi
I have an application in vb.net and sql server 2005.
sql server 2005 is installed in my pc.
I want to run the application in other pc.
both pcs are connected in LAN.
Now whenever I am running application in other pc it is showing an error as SQL SERVER DOES NOT EXIST OR ACCESS DENIED.
I am not getting it.
Can anybody help me on this.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-09-14 : 03:40:20
you should add both the machines to same domain and then create a application role in sql server for use by application. then set config of application to use this credential and to connect to sql server in your pc

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

manisha.vk
Starting Member

17 Posts

Posted - 2011-09-14 : 05:09:42
Thanks for reply but can you please eloborate the things
because i am new to all these.

Thanks!!!!!!!!!
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-09-14 : 10:50:32
see below
adding machine to domain
http://support.microsoft.com/kb/295017

creating application role

http://msdn.microsoft.com/en-us/library/ms181491.aspx

adding app role

http://www.codeproject.com/KB/database/AppRole.aspx

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -