September 17, 2008 at 2:34 am
Hi
I have sql server 2005 installed on my server. I have scripted out the db in my web app from vis web dev and loaded the db into my server all ok.
My connection string is connecting to the server ok.
The sql server user is granted access and the same user is granted access to my db.
The asp.net security is all working fine ...membership / passwords etc but when my web app tries to connect to my tables in the same db it fails. I,m getting the old ...not allowed remote connections error 40
Previously I used to run this web app in another server all ok.
But my previous web config even after alterations only gives me half access.
As i said before all membership and tables are in the same db.
I,m baffled........any ideas gladly excepted.
Richard
September 17, 2008 at 8:36 am
Are remote connections allowed on the SQL Server? By default SQL Server 2005 does not have Named Pipes or TCP enabled.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
September 17, 2008 at 8:40 am
remind me how to open connections
September 17, 2008 at 9:11 am
You use the SQL Server Configuration Manager.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
September 17, 2008 at 4:08 pm
Yea tcp/ip and named pipes enabled.
My old con string used to have two parts...now only the top half seems to work.
ow found an error whilst typing thisout
standby
September 17, 2008 at 4:27 pm
I have the .net security assembly in the same db as my personal tables.
I can access the .net security stuff but get the error 40 when accessing my
tables.
previous error in con string went no where.
its a bit of a head scratcher
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply