Click here to Skip to main content
16,022,417 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
i write a win app for the my local network and i create my database with code,now when every user wants to connect to my database that is on server system this error ocurred:the login failed by domainname/username".

how can set remote access(full access)for all the users on my local network??i want do this isue with code .

thanks in advance.
Posted
Comments
Wonde Tadesse 9-May-11 19:35pm    
Can you post the database connection string ?

is the SQL server installed on your computer>? what is the connection string that you are using?
 
Share this answer
 
Try this script


SQL
EXEC sys.sp_configure N'remote access', N'1'
GO
RECONFIGURE WITH OVERRIDE
GO
 
Share this answer
 
no sql server installed on server system,and it's my connection string :
ConnectionString=@"Data Source=SERVER\SQLEXPRESS;Initial Catalog=test;Integrated security=SSPI;Persist Security Info=False";  
 
Share this answer
 
SQL
Also check your sql conenction string. Is it universal or only for your computer. If it is like this;
"Data Source= PC1\SQLEXPRESS;Initial Catalog=DatabaseName;Integrated Security=true;" change the PC1 to "." so others can conenct to it. "Data Source= .\SQLEXPRESS;Initial Catalog=DatabaseName;Integrated Security=true;"
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900