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 |
|
ShiftySid
Starting Member
5 Posts |
 Posted - 2009-01-14 : 14:21:12
|
| I am using Visual Studio Professional 2008 with SQL Server Express 2008. Both work fine in their own right, but...1) If I go into SQL Management Stuido, browse a database or sp or table etc, then close it down and go into Visual Studio and then open my VB Application, it fails to connect to SQL saying the database can not be found.If I stop/start the SQLServer Service and close/restart Visual Studio, it's fine.2) The reverse is also true. If working in VB, then wanting to access SQL I have to stop/start the SQLServer service. Even if accessing the SQL tables direct through Visual Studio itself - as soon as a Database object is expanded, it requires SQL to be re-started.Anyone have any ideas why?I've tried using both Windows and SA authentication, neither seem to make any difference with this issue.Please help!Thanks,Shifty. |
|
|
|
|
|
SQL Management Studio Problem