«

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

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

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

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

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