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.
| Author |
Topic |
|
Jimmyborofan
Starting Member
1 Post |
 Posted - 2008-05-22 : 18:32:32
|
| Please help!I have just set up SQL server and Visual Studio Pro to set up a development machine for a uni course I am doing, I have begun writing databases and at first everything seems okay, I write a small app fire it off in debug and all works, then without warning Visual Studio is unable to connect to the database despite using the corrrect credentials, I knows its an SQL problem because I get a server error through IIS telling me that it cannot connect through <em>ComputerName\LoginName</em>if i turn everything off and restart IIS I can get a connection but then despite it retrieveing the database when testing a query (within the add SQL connection form in VS2008, it shows the table info)Then once again al is lost and it refuses to tafe valid connections until I restart (however I CAN login through SQL Management)Any suggestions gratefully recieved!JimmyMe transmitte sursum, caledoni |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-22 : 23:08:09
|
| Did you add ComputerName\LoginName as sql login in sql server yet? |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-05-23 : 00:52:53
|
| Please post your error message.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Database maintenance routines:http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx |
|
|
|
|
|
|
I am soo frustrated!