re. Access denied or sql server doesnt exists

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

General SQL Server Forums

New to SQL Server Programming

re. Access denied or sql server doesnt exists

Author

Topic

infox45
Starting Member

7 Posts

Posted - 2008-01-18 : 23:39:48

Hi

I am using sql sever 2000 installed with sql authentication on windows 2003 server with SP2.

I have developed application on vb.net 2005.

When i am go to client system then my applciation doesnt start. for that i have to go to start->run then type \\server and i have to enter username password.after that i can connect to my application.

plz help regarding to solve this issue. we wasting lots of time behind this.

Thanks

Prakash

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2008-01-19 : 00:41:01

open enterprise manager....register your server..go to your server......select security.....select logins....
there click on your user name.....then right click and properties.....there you can find the database access tab. there check your database to be checked in. then in the roles,select db reader, dbwriter, public,dbowner.
i think this can slove your problem

Vinod
Even you learn 1%, Learn it with 100% confidence.

infox45
Starting Member

7 Posts

Posted - 2008-01-19 : 02:31:49

But Dear Vinod

i am using sa with blank password and sa have all rights by default. and i am not using domain server.

on client when i open my applciation i got err "sql server doesnot exists or access denied" for that i go to start->run then type \\server and then i enter username and password. after that i can connect to my application .this i have to done each time when i restart server or restart/logoff my client system/pc.this means that i have to authentication to server each time when i logoff from windows from client.

Prakash

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2008-01-19 : 03:11:03

you have checked the option prompt everytime. uncheck the option.

right click on server, edit sql server registration properties...there uncheck always frompt for login and username.

let us know it worked fine......or not

Vinod
Even you learn 1%, Learn it with 100% confidence.

infox45
Starting Member

7 Posts

Posted - 2008-01-19 : 03:40:00

i am not talking abt sql server client i am talking abt my application created in .net 2005.

when i open my .net exe from other(in network)sysytem i shows error "SQL server doent not exists or access denied". then i am go to start ->run->then type \\server then i enter username and password of server administrator then password.

then again i am open my .net exe now i can open my applciation sucessfully.

this thing i have to done each time when i logff and login from windows.

Prakash

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2008-01-19 : 03:49:28

infox45
Starting Member

7 Posts

Posted - 2008-01-19 : 03:54:09

i am talking abt my application created in .net 2005.

when i open my .net exe from other(in network)sysytem i shows error "SQL server doent not exists or access denied". then i am go to start ->run->then type \\server then i enter username and password of server administrator then password.

then again i am open my .net exe now i can open my applciation sucessfully.

this thing i have to done each time when i logff and login from windows.

Prakash

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-01-20 : 20:34:40

What's connection string in your app?

infox45
Starting Member

7 Posts

Posted - 2008-01-25 : 01:43:38

connectionString="Data Source=server;Initial Catalog=eCFS2;User ID=sa;Persist Security Info=True"

Prakash

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-01-25 : 23:33:42

You have to provide password when use sql authentication, check http://www.connectionstrings.com/ for samples.