 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
.NET Forum / Visual Studio.NET / IDE / August 2005VSnet.ide cannot see local SQL db, but Enterprise Manager can
Hi, I have inexplicably lost my SQL Server connection to my local SQL Server inside VS.Net IDE, but I can still access it with Enterprise Manager. If I try to access it with a udl file on my desktop I get this error: "Test connection failed because of an error in initializing provider. [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. How could it be that Enterprise Manager can still see and manipulate the SQL db, but VS.NET or a udl file cannot? I am using Windows Integrated Security and the only thing I can think of that I have changed is that I created an ODBC connection to a local SQL Server db using Access 2003. Hope you can help. Gwenda Hi, Currently we are finding one support engineer for you on this issue. If any result, we will update you at the first time. Best Regards, Wei-Dong XU Microsoft Product Support Services This posting is provided "AS IS" with no warranties, and confers no rights. Hi Gwenda, >I have inexplicably lost my SQL Server connection to my local SQL >Server inside VS.Net IDE, but I can still access it with Enterprise Manager. >If I try to access it with a udl file on my desktop I get this error: "Test >connection failed because of an error in initializing provider. >[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or >access denied. Based on the error message, it appears the related data source provider was corrupted by chance. In this scenario, I suggest you reinstall the latest MDAC to your machine at first: Microsoft Data Access Components (MDAC) 2.8 SP1 http://www.microsoft.com/downloads/details.aspx?familyid=78CAC895-EFC2-4F8E- A9E0-3A1AFBD5922E&displaylang=en If it could fix the problem, the you can perform a reparation of your VS.NET 2003, hope this helps. >How could it be that Enterprise Manager can still see and >manipulate the SQL db, but VS.NET or a udl file cannot? The Enterprise Manager is a part of the SQL Server system, it is an administrator tool utility of the SQL Server, it don't need a MDAC provider to access the SQL server database... Thanks! Best regards, Gary Chang Microsoft Community Support -------------------- Get Secure! ¡§C www.microsoft.com/security Register to Access MSDN Managed Newsgroups! http://support.microsoft.com/default.aspx?scid=/servicedesks/msdn/nospam.asp &SD=msdn This posting is provided "AS IS" with no warranties, and confers no rights. Hi Gary - I will follow your advice, but what do you mean by: > If it could fix the problem, the you can perform a reparation of your > VS.NET 2003, hope this helps. What is a "reparation" - do you mean re-install VS.NET 2003? >> If it could fix the problem, the you can perform a reparation of your >> VS.NET 2003, hope this helps. > >What is a "reparation" - do you mean re-install VS.NET 2003? yes, I mean the Repair/Reinstall option of the VS.NET 2003 setup program. By the way, you can also try to reinstall the MSDE 2000 for the VS2003: MSDE 2000 for Developers Using Visual Studio .NET http://www.microsoft.com/downloads/details.aspx?FamilyId=A0DAC778-60A6-4B11- 8AA8-BF12261A303A&displaylang=en Thanks! Best regards, Gary Chang Microsoft Community Support -------------------- Get Secure! ¡§C www.microsoft.com/security Register to Access MSDN Managed Newsgroups! http://support.microsoft.com/default.aspx?scid=/servicedesks/msdn/nospam.asp &SD=msdn This posting is provided "AS IS" with no warranties, and confers no rights. Gary - I don't have MSDE installed - so will this still help, or should I start by trying the latest MDAC? Gwenda > >> If it could fix the problem, the you can perform a reparation of your > >> VS.NET 2003, hope this helps. [quoted text clipped - 22 lines] > > This posting is provided "AS IS" with no warranties, and confers no rights. Hi Nina, I suggest you first install the latst MDAC, if it doesn't work, then try the MSDE package... Thanks! Best regards, Gary Chang Microsoft Community Support -------------------- Get Secure! ¡§C www.microsoft.com/security Register to Access MSDN Managed Newsgroups! http://support.microsoft.com/default.aspx?scid=/servicedesks/msdn/nospam.asp &SD=msdn This posting is provided "AS IS" with no warranties, and confers no rights. Hi Gary - I'm running Windows XP and the MDAC package is not available as a separate download except for earlier versions of Windows. In XP, MDAC is part of SP2. Do you think I should reinstall SP2? I've tried running the Repair feature in VS install but it had no effect. I haven't tried installing MSDE yet. Thanks, Gwenda > Hi Nina, > [quoted text clipped - 14 lines] > > This posting is provided "AS IS" with no warranties, and confers no rights. Hi Gary, I installed MSDE with the options suggested on the page you sent me to: Setup.exe /qb+ INSTANCENAME=VSDOTNET DISABLENETWORKPROTOCOLS=1 SAPWD=<YOUR SA PASSWORD> I can register this instance in Enterprise Manager, but cannot connect to it from VS, altho a connection automatically appeared in VS. I just noticed that SQLServer no longer in my System Tray, altho its status is STARTED in Services Manager. I'm going to try reinstalling SP2 for Windows XP. Gwenda > Hi Nina, > [quoted text clipped - 14 lines] > > This posting is provided "AS IS" with no warranties, and confers no rights. Hi Gary - I now have the new instance connecting in VS. How? -In Enterprise Manager, I added a new login for the new MSDE instance, choosing SQL Server Authentication instead of Windows, then under DatabaseAccess tab, selected databases and made this user "owner". In VS, I unregistered my new instance of MSDE and then re-registered it, and immediately it became available. I thought it was going to ask me for login and pw, but it didn't. Try as I might, I cannot get the connection to my SQLServer instance working. Do you think I should try re-installing SQLServer, instead of reinstalling SP2? Gwenda > Hi Gary, I installed MSDE with the options suggested on the page you sent me > to: [quoted text clipped - 28 lines] > > > > This posting is provided "AS IS" with no warranties, and confers no rights. Hi Gwenda >I now have the new instance connecting in VS. How? -In Enterprise Manager, >I added a new login for the new MSDE instance, choosing SQL Server [quoted text clipped - 6 lines] > >Try as I might, I cannot get the connection to my SQLServer instance working. Do you mean your VS.NET has already got a new instance connecting to the SOL Server, but it just doesn't work? >Do you think I should try re-installing SQLServer, instead of reinstalling >SP2? It depends on whether your SQL Server works alright or not, I don't think you need to re-install the SQL Server only because it could not be accessed by the VS.NET Server Explorer... Thanks for your understanding! Best regards, Gary Chang Microsoft Community Support -------------------- Get Secure! ¡§C www.microsoft.com/security Register to Access MSDN Managed Newsgroups! http://support.microsoft.com/default.aspx?scid=/servicedesks/msdn/nospam.asp &SD=msdn This posting is provided "AS IS" with no warranties, and confers no rights. Hi Gary - I have installed MSDE as suggested by you and am able to connect to it in VS and EM, so I have used DTS to transfer all my data to the new MSDE instance and I'm happy. I think MSDE will be just as good for development as full-blown SQL Server. Thanks, Gwenda > Hi Gwenda > [quoted text clipped - 35 lines] > > This posting is provided "AS IS" with no warranties, and confers no rights. It's great, Gwenda, we are glad to know this problem has been fixed:) Thanks! Best regards, Gary Chang Microsoft Community Support -------------------- Get Secure! ¡§C www.microsoft.com/security Register to Access MSDN Managed Newsgroups! http://support.microsoft.com/default.aspx?scid=/servicedesks/msdn/nospam.asp &SD=msdn This posting is provided "AS IS" with no warranties, and confers no rights. Free MagazinesGet these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...
|
Reply to this Message
|
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.