By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,678 Members | 2,192 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,678 IT Pros & Developers. It's quick & easy.

Sql server dose not exist or access denied

P: n/a
Hi:
i have one asp.net application.From this application i am connecting to sql
sever on domain.Earlier it was connecting.After i reinstalled the sql sever
and try to open the connection ,it is giving error
Sql server dose not exist or access denied.
From query analyzer i am getting connection.
What will b ethe possible cause

Please let me know
Aug 8 '06 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Check your connection string. See if you can refresh schema in the designer.
Might be the connection protocol is sql server local to the application
server or remote?

"jdubey" wrote:
Hi:
i have one asp.net application.From this application i am connecting to sql
sever on domain.Earlier it was connecting.After i reinstalled the sql sever
and try to open the connection ,it is giving error
Sql server dose not exist or access denied.
From query analyzer i am getting connection.
What will b ethe possible cause

Please let me know
Aug 8 '06 #2

P: n/a
HI:
Ihe connection string is like this
Persist Security Info=False;Data Source=indidev;Initial Catalog=REED;User
ID=reed;Password=reed;Min Pool Size=1;Max Pool Size=10000
Earlier it was connectiing .
Now is is not connecting .What u replied ,can u explain it.
Thanks
Aug 8 '06 #3

P: n/a
HI:
Ihe connection string is like this
Persist Security Info=False;Data Source=indidev;Initial Catalog=REED;User
ID=reed;Password=reed;Min Pool Size=1;Max Pool Size=10000
Earlier it was connectiing .
Now is is not connecting .What u replied ,can u explain it.
Also in schema i am getting refreshed
Thanks

Aug 8 '06 #4

P: n/a
jdubey,
Make sure the reinstalled SQL Server has both SQL Server and Windows ("Mixed
mode") authentication enabled, and that it is set to listen on the default
port, and that it is not set to "hide server". You can also try using the IP
address of the server instead of the name. BTW, that 10,000 max on the pool
is a huge number, and could cause real problems. The default of 100
connections is sufficient for 95% of all applications, as long as
connections are closed when each unit of work is done.
Peter

--
Co-founder, Eggheadcafe.com developer portal:
http://www.eggheadcafe.com
UnBlog:
http://petesbloggerama.blogspot.com


"jdubey" wrote:
HI:
Ihe connection string is like this
Persist Security Info=False;Data Source=indidev;Initial Catalog=REED;User
ID=reed;Password=reed;Min Pool Size=1;Max Pool Size=10000
Earlier it was connectiing .
Now is is not connecting .What u replied ,can u explain it.
Thanks
Aug 8 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.