Hello,
I have MSDE Installed on a different computer (WIndows 2003) within my
network. I also have MSDE Installed on my production computer for
development.
I have successfully created databases on both computers using OSQL. What I
would really like to accomplish is a connection from the Server Explorer in
Visual Studio .NET.
I have a successful connection to the local instance of MSDE and I added my
server to the server list with no problems.
But, this is where the problem comes in.
Lets Say my Server is called Moon, The Servers Tree in Server Explorer
shows Moon, I can access the Event Logs, Message Queues, Performance
Counters and Services with on problem. But, when I click on SQL Servers
Moon is shown with a Red X, I click the Plus (+) sign, type in the Login and
Password, I receive the following Error:
{DBNETLIB}{Conn ectionOpen (Connect().]SQL Server does not exist or access
denied.
Any Suggestions will be greatly appreciated,
Chuck 3 1326
hi Chuck,
Charles A. Lackman wrote: Hello,
I have MSDE Installed on a different computer (WIndows 2003) within my network. I also have MSDE Installed on my production computer for development.
I have successfully created databases on both computers using OSQL. What I would really like to accomplish is a connection from the Server Explorer in Visual Studio .NET.
I have a successful connection to the local instance of MSDE and I added my server to the server list with no problems.
But, this is where the problem comes in.
Lets Say my Server is called Moon, The Servers Tree in Server Explorer shows Moon, I can access the Event Logs, Message Queues, Performance Counters and Services with on problem. But, when I click on SQL Servers Moon is shown with a Red X, I click the Plus (+) sign, type in the Login and Password, I receive the following Error:
{DBNETLIB}{Conn ectionOpen (Connect().]SQL Server does not exist or access denied.
the most probable causes of this problem are listed in http://support.microsoft.com/default...06&Product=sql
.... please check with the Server Network Utility that the Moon MSDE instance
has enabled network protocols, as MSDE installs by default allowing local
connections only...
--
Andrea Montanari (Microsoft MVP - SQL Server) http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
DbaMgr2k ver 0.16.0 - DbaMgr ver 0.61.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply
Read my How to (Msde related) at: http://spaces.msn.com/members/sholliday/
12/16/2005 entry date.
The key is the
[Options]
DISABLENETWORKP ROTOCOLS=0
SECURITYMODE=SQ L
stuff.
Use the KB mentioned earlier, to manually make the fix.
My stuff will teach you how to avoid the issue in the future, if you
ever install MSDE again.
(Or if you get really really stuck and need to start over)
Charles A. Lackman wrote: Hello,
I have MSDE Installed on a different computer (WIndows 2003) within my network. I also have MSDE Installed on my production computer for development.
I have successfully created databases on both computers using OSQL. What I would really like to accomplish is a connection from the Server Explorer in Visual Studio .NET.
I have a successful connection to the local instance of MSDE and I added my server to the server list with no problems.
But, this is where the problem comes in.
Lets Say my Server is called Moon, The Servers Tree in Server Explorer shows Moon, I can access the Event Logs, Message Queues, Performance Counters and Services with on problem. But, when I click on SQL Servers Moon is shown with a Red X, I click the Plus (+) sign, type in the Login and Password, I receive the following Error:
{DBNETLIB}{Conn ectionOpen (Connect().]SQL Server does not exist or access denied.
Any Suggestions will be greatly appreciated,
Chuck
Hello,
I found a way to fix the problem,
Below is what I needed to do.
Run the svrnetcn.exe on which you installed MSDE It will show you SQL Server
Network Utility Dialogbox, Make sure that TCP/IP is enabled and the port is
1433.
Chuck
"Charles A. Lackman" <Ch*****@Create ItSoftware.net> wrote in message
news:O%******** *******@TK2MSFT NGP11.phx.gbl.. .
Hello,
I have MSDE Installed on a different computer (WIndows 2003) within my
network. I also have MSDE Installed on my production computer for
development.
I have successfully created databases on both computers using OSQL. What I
would really like to accomplish is a connection from the Server Explorer in
Visual Studio .NET.
I have a successful connection to the local instance of MSDE and I added my
server to the server list with no problems.
But, this is where the problem comes in.
Lets Say my Server is called Moon, The Servers Tree in Server Explorer
shows Moon, I can access the Event Logs, Message Queues, Performance
Counters and Services with on problem. But, when I click on SQL Servers
Moon is shown with a Red X, I click the Plus (+) sign, type in the Login and
Password, I receive the following Error:
{DBNETLIB}{Conn ectionOpen (Connect().]SQL Server does not exist or access
denied.
Any Suggestions will be greatly appreciated,
Chuck This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Leisa |
last post by:
Hello. I have visual studio professional version 2003,
and I'm trying to connect to our Oracle database. I've
tried using the Oracle native driver, the MS provider for
ODBC, the MS provider for Oracle, but none of them work.
When I test the connection, it succeeds, but then it
tells me that this version of Visual Studio can only
connect to SQL Server Desktop Engine or MS Access
databases. The reason I upgraded to Visual Studio pro
ver....
|
by: Krish |
last post by:
Hi Friends,
Does anyone know how to connect access database into Visual C++ in
Visual Studio 6.0. I know the procedure to connect access database
into Visual Studio .Net. But Visual Studio 6.0 is more complicted
than .Net. Can someone help me pls?
Thanks
Krish
|
by: Krish |
last post by:
Hi Friends,
Does anyone know how to connect access database into Visual C++ in
Visual Studio 6.0. I know the procedure to connect access database
into Visual Studio .Net. But Visual Studio 6.0 is more complicted
than .Net. Can someone help me pls?
Thanks
Krish
|
by: Jerry Higgins |
last post by:
In Interdev 6.0 you can connect to an existing web. I've
looked through the help and I haven't found a way to do
it. Any ideas?
Thanks,
Jerry
|
by: ben_chicago |
last post by:
I JUST INSTALLED Visual Basic.NET BUT, CANNOT CONNECT TO MY
AS/400
(OS400 5.1). WHEN I TRY TO CONNECT I GET A SERVER EXPLORER MSG:
"UNABLE TO CONNNECT TO DATABASE.
IT IS ONLY POSSIBLE TO CONNECT TO SQL SERVER DESKTOP ENGINE DATABASES
AND MICROSOFT ACCESS DATABASES WTIH THIS VERSION OF VISUAL STUDIO."
-What Version Of Visual Studio do I need?
| |
by: acwomble |
last post by:
I am working with a database on another system via a ssh tunnel using
plink. We have setup an alias the local system for the remote database.
I am able to connect and work from within Visual Studio if I connect to
the remote database using with "SQL Server" as the data source and
".NET Framework Data Provider for OLEDB" as the data provider . If I
change the data provider to ".NET Framework Data Provider for SQL
Server" I get the...
|
by: axel22 |
last post by:
Ok, I've installed MS Sql Server Express, and I've created a database
'ProbnaBaza' and a table 'clan' in Management Studio. I tried using the
database locally through a project in Visual
Studio. I used the following connection string:
"Server=.\\SQLEXPRESS;Initial Catalog=clan;Integrated Security=SSPI";
It worked perfectly.
Then, I tried using the database by setting an IP address within the
connectionString,
|
by: TerpZebra |
last post by:
I am having difficulty connecting to SQL Server 2000 on one of our
servers via a VB6 program on Vista. I can connect fine to a different
server, but it gives me the following error with the server in
question:
"Unable to connect to database. Please check your internet connection
Error# -2147467259
SQL Server does not exist or
access denied"
|
by: samadams_2006 |
last post by:
Hello,
I have a problem that I'm hoping someone will be able to help me
resolve.
1) I have a C# Web Site in which I connect to the database: "Install
Microsoft SQL Server 2005 Express Edition" via the link on:
http://msdn2.microsoft.com/en-us/express/bb410792.aspx
|
by: megaman1 |
last post by:
I’m trying to connect with perl DBD::Oracle on Windows to Oracle DB (Linux).
I compiled the Oracle.dll using the commands “perl Makefile.pl” “nmake” and “nmake install”, but when I try to connect to the DB, I get the following runtime error:
“R6034 an application has made an attempt to load the C Runtime library incorrectly.
Please contact the applications’ support team for more information.”
I suspect that I mixed the versions of VC...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
| |
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |