February 26, 2010 at 9:06 pm
I'm a novice and would welcome any help on this, since I've been scouring left and right for answers to no avail. Am I missing the framework for the architecture...
I've set up a database using SQL Server Express Management Studio (2008)--and then attached it to my unpublished website...all on the same machine.
Problem is that each time I open my website application and "browse" an aspx page (that displays data from that database), my database (back on Management Studio turf) becomes "inaccessible"---temporarily. And the converse is true. If I open my database using Management Studio first---the aspx page back at the website stumbles with the dreaded "can't open default database. Login failed. Machine\User cannot log in".
However, when I shutdown and reboot the computer (not simply restart, though), all is forgiven: the database is accessible again or the web page displays the database data fine---they just can't both get along with each other in the same "session".
Is this normal? Does this mean only one user at a time can connect to the database??...."Can't I have my query---and execute it too?"...What simple fix eludes me?
Please help. Thanks in advance. --Matt
March 3, 2010 at 9:53 pm
March 4, 2010 at 12:44 pm
If the Pages in your application are accessing the Database.....u need to setup permissions to execute scripts on your Database..for that user...
March 4, 2010 at 11:47 pm
do you use dynamic IP or fixed IP?
you can try to disable both named pipe and TCP/IP protocol (keep only shared memory enabled).
also, what is the default database for your domain\login ? can you change it to master, temporarily?
in your web app's connection string, do you use machine name or IP to connect? did you try to disconnect all your network connections and run your app again?
not sure whether this will help though. 🙂
March 4, 2010 at 11:57 pm
It seems that the application and database are competing for resources - memory being a good contender.
What are your memory settings for sql server?
Also, I would tune your sql queries that are coming from the app.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply