cannot connect to the server

hello,
i want to install sql server 2000 in my machine which has win xp. now the
problem is that it does not get connected to the server. error message comes
that there is a connection failure.
pls help me
thank u
bituDid you configuire the firewall to let the appropiate ports SQL Server
is configured for let through ?
HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de
--

cannot connect to the server

hello,
i want to install sql server 2000 in my machine which has win xp. now the
problem is that it does not get connected to the server. error message comes
that there is a connection failure.
pls help me
thank u
bitu
Did you configuire the firewall to let the appropiate ports SQL Server
is configured for let through ?
HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de

cannot connect to SQL database through IIS

Hello,

I'm new...

I've installed Web Matrix, and MDSE. I've been successful in installing the Time Tracker Starter kit, I've connected to multiple databases (SQL and Access) within Web Matrix and I'm now trying to connect to my own SQL database...with limited success.

Scenario:
I've created a SQL database using MS Access (*.adp) access project for SQL. I've created a new ASPX with Web Matrix and placed a database table into my new ASPX by draggin-n-droppin the table from the DATA connections in Web Matrix. Everything goes smoothly...

When I view the page using the Web Matrix 'built-in' web server (i.e. http://localhost:8080/default.aspx), everything displays just fine...it appears that the script is connecting properly to the database and executing the query without any problem -- I can view my data within the page. However, when I view this page using IIS (i.e. http://localhost/default.aspx), I get:
System.Data.SqlClient.SqlException: Cannot open database requested in login 'myDB'. Login fails. Login failed for user 'MYCOMPUTER\ASPNET' and then a stack dump.

Same code...different web servers...different results.

I've checked as many SQL permissions as I could think of, but my experience with SQL is limited. I'm using Microsoft's FREE SQL tools, but I'm pretty certain that there should be a simple way to ensure that my ASPNET user account has appropriate permissions to access my SQL database through IIS.

any suggestions?As you can see the sql error is occuring as the ASPNET account on your machine doesn't have sql priveleges - to solve this you could either add the apsnet account to sql logins and give it sufficient permissions or impersonate and identity which has sufficient sql priveleges.

Hope that helps
Kashif|||I have the same problem .
Would you please tell me how to add the apsnet account to sql logins .|||You can either run the following stored procedure to add the aspnet account

sp_grantlogin @.loginame

in your case @.login name would be "MachineName\ASPNET" or if you have SQL Enterprise Manager you can open the sql server you want to add the login to and then select security -> Logins -> NewLogin

Hope that helps
Kashif|||Thank you so much. However, I do have MSDE on my Windows XP machine.
and stil have the same problem.
your help will be appreciated.|||To installed MSDE on your system with SQL authentication support use this command:
Setup SAPWD=(Some password) SecurityMode=SQL

where setup is the executable of the setup of MSDE (download it over here with SP3 integrated:http://www.asp.net/msde/default.aspx?tabindex=0&tabid=1). Follow the instructions of the setup.

When you've done so, you can login to the MSDE database using this credentials:
uid=sa
pwd=(Some password)

Replace the (Some password) in the command line by the password you like.|||Thank you so much for your response however I already done that but it doesn't work:
This is my frist samle project for MSDE so would tell me the steps:
1. Create a project by MS Access and login='sa' password='passowrd'. that mean the SQL server is running and it's shown at my desck top.
2. write a small ample of aspx code by WebMatrix
3, it gives me the "Cannot open database requested in login 'adp1'. Login fails. Login failed for user 'sa'."

<%@. Page Language="C#" %>
<%@. import Namespace="System.Data" %>
<%@. import Namespace="System.Data.OleDb" %>
<%@. import Namespace="System.Data.SqlClient" %>
<script runat="server"
 void Page_Load(object sender, EventArgs e) {
 // TODO: Update the ConnectionString and CommandText values for your application
 string ConnectionString = "server=(local);database='adp1';uid='sa'; pwd='password'";
 string CommandText = "select * from news";
 SqlConnection myConnection = new SqlConnection(ConnectionString);
 SqlDataAdapter objCmd1 = new SqlDataAdapter( CommandText, myConnection);
 DataSet ds1 = new DataSet();
 objCmd1.Fill(ds1);
 //myDataList1.DataSource = ds1;
 //MyDataList1.DataBind();
 }
</script>
<html>
<head>
</head>
<body style="FONT-FAMILY: arial">
 <h2>Simple Data Report
 </h2>
 <hr size="1" />
 <ASP:DataList id="MyDataList1" RepeatColumns="1" RepeatDirection="Horizontal" runat="server">
 <ItemTemplate>
 <table border="0" cellpadding="2" width="100%" height="68">
 <tr valign="TOP">
 <td width="20%" valign="top" rowspan="2" height="62">
 Hello
 </td>
 <td width="80%" valign="top" height="7">
 <font face="Verdana" size="2"> <%# DataBinder.Eval(Container.DataItem, "news_title") %> <font face="Verdana" size="1.5"><%# DataBinder.Eval(Container.DataItem, "news_date") %> </font> </font></td>
 </tr>
 <tr>
 <td width="70%" valign="top" height="49">
 <font face="Verdana" size="1.5"> <%# DataBinder.Eval(Container.DataItem, "news_description") %> </font>
 </td>
 </tr>
 </table>
 </ItemTemplate>
 </ASP:DataList>
</body>
</html>

|||From the error it seems the password you are using for sa is incorrect, can you try running some sql scripts from command line using login sa and password password and see if you are able to run those.

-Kashif|||thank you so muh, I am sorry but I been away for a short vacation.
This is my frist samle project for MSDE so would tell me the steps.
I do not have SQL Server..
Would you tell me how to check these command. ...

sat|||Open command prompt, switch to binn directory msde and run something like the following

osql -U sa id -P myPwd -S (.) -d Northwind -q "Select * from customers"

if this fails to run then we know that you are either not setting the sa password right or the MSSQL service is not running on your machine. Also if you have a named instance of MSDE installed then you would use "-S ServerName\InstanceName"

Hope that helps
Kashif|||Thank you.
I have created MS Acces project called adp1. wehn I open the project it asks me for user "sa" and password. I have database tables "news". however when I write the following:
>osql -U sa -P password -S (.) -D adp1 -Q "Select * from news"

Error " Data Source name not found and no default driver"

>osql -U sa -P password -S localhost\adp1 -D adp1 -Q "Select * from news"

Error " Data Source name not found and no default driver"|||actullay, after I run the previous command I got this error on my
http://localhost/

403 Forbidden - The server denies the specified Uniform Resource Locator (URL). Contact the server administrator. (12202)
Internet Security and Acceleration Server.

any explations please..!!! thank you|||The error you have specified above just implies that there is no page defined. Can you look up the Default wesite's home directory and see the "Default document" tab.

-Kashif|||Hello all,

I am writing this message simply because I started this thread and I wanted to remark that with ALL your help, and with many hours of studying SQL server permissions, osql commands and syntax, SQL server port configuration and firewalls, I have resolved the problems I was having when I started this thread.

Thanks to all who provided excellent advice and tolerated my previous ignorances.

Regards.

Cannot Connect to SQL 2000 on Win2k3 Server

I am having great difficulty connecting to my sql box, I
vpn'd in from work and connected via remote desktop,
setup the SQL connection locally, and connected fine,
which I am wondering if it was cause I was VPN'd in, but
I disconnected from remote desktop and was still able to
hit my sql server in enterprise manager. Then when I got
home tonight, logged on my XP machine and I cannot get my
sql registration to connect.
SQL Server does not exist or access denied ConnectionOpen
(Connect()
I have no idea what this means...I am just learning SQL
so this is all new to me...please help...I am on a home
network behind a linksys router, both my XP box and the
Win2k3 box are behind the router which has a dynamic ip
for the XP box, and a static one for the 2k3 box.On Windows 2003, if there are any instances of SQL Server installed that
are not on SP3 or higher, TCP will be disabled (there will be messages in
the event logs indicating this). In that case remote connections would fail
because by default clients try to connect with TCP. Upgrade all instances
on the box to SP3 then retry connecting. You can also try to connect from
the remote machines using named pipes (add np: before the machine\instance
in your connection string).
328306 INF: Potential Causes of the "SQL Server Does Not Exist or Access
http://support.microsoft.com/?id=328306
Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.

Cannot connect to Local SQL Server

I am having trouble connecting to my local sql server from either the Server
Explorer or vb.net code. The problem is connected to the Norton Internet
Security 2005 Firewall as when I disable Norton everything works and if
Norton is enabled but the PC is not plugged into the network it also works.
When I am connected to the network the Firewall does pop up asking whether
or not I want to allow my vb.net program to access a DNS. I have tried using
localhost, the hardcoded IP of my machine, and my machine name (the usual
method) without any success. It is as if Visual Studio always tries to
resolve the machine name and cannot. VB6 programs ,dbArtisan, and SQL
Enterprise Manager all work fine at the same time Visual Studio/VB.Net does
not.
Any ideas?
Thanks,
Mark Lewis
mdlewis@.mdlewis.com
P.S I am using the latest production/old Visual Studio and SQL Server on XP
with all SP applied.here's an idea: configure the Norton product so that your machine can access
DNS.
-- Nick Malik [Microsoft]
MCSD, CFPS, Certified Scrummaster
http://blogs.msdn.com/nickmalik
Disclaimer: Opinions expressed in this forum are my own, and not
representative of my employer.
I do not answer questions on behalf of my employer. I'm just a
programmer helping programmers.
--
"Mark Lewis" <mdlewis@.mdlewis.com> wrote in message
news:u$P2swmHFHA.3336@.TK2MSFTNGP10.phx.gbl...
>I am having trouble connecting to my local sql server from either the
>Server Explorer or vb.net code. The problem is connected to the Norton
>Internet Security 2005 Firewall as when I disable Norton everything works
>and if Norton is enabled but the PC is not plugged into the network it also
>works.
> When I am connected to the network the Firewall does pop up asking whether
> or not I want to allow my vb.net program to access a DNS. I have tried
> using localhost, the hardcoded IP of my machine, and my machine name (the
> usual method) without any success. It is as if Visual Studio always tries
> to resolve the machine name and cannot. VB6 programs ,dbArtisan, and SQL
> Enterprise Manager all work fine at the same time Visual Studio/VB.Net
> does not.
> Any ideas?
> Thanks,
> Mark Lewis
> mdlewis@.mdlewis.com
> P.S I am using the latest production/old Visual Studio and SQL Server on
> XP with all SP applied.
>|||Resubmitting this with my new MSDN Alias.
Thanks,
Mark Lewis
mdlewis@.mdlewis.com
"Mark Lewis" <mdlewis@.mdlewis.com> wrote in message
news:u$P2swmHFHA.3336@.TK2MSFTNGP10.phx.gbl...
>I am having trouble connecting to my local sql server from either the
>Server Explorer or vb.net code. The problem is connected to the Norton
>Internet Security 2005 Firewall as when I disable Norton everything works
>and if Norton is enabled but the PC is not plugged into the network it also
>works.
> When I am connected to the network the Firewall does pop up asking whether
> or not I want to allow my vb.net program to access a DNS. I have tried
> using localhost, the hardcoded IP of my machine, and my machine name (the
> usual method) without any success. It is as if Visual Studio always tries
> to resolve the machine name and cannot. VB6 programs ,dbArtisan, and SQL
> Enterprise Manager all work fine at the same time Visual Studio/VB.Net
> does not.
> Any ideas?
> Thanks,
> Mark Lewis
> mdlewis@.mdlewis.com
> P.S I am using the latest production/old Visual Studio and SQL Server on
> XP with all SP applied.
>|||Resubmitting this with my new MSDN Alias to qualify for support.
Thanks and sorry about the double post,
Mark Lewis
mdlewis@.mdlewis.com
"Mark Lewis" <mdlewis@.mdlewis.com> wrote in message
news:u$P2swmHFHA.3336@.TK2MSFTNGP10.phx.gbl...
>I am having trouble connecting to my local sql server from either the
>Server Explorer or vb.net code. The problem is connected to the Norton
>Internet Security 2005 Firewall as when I disable Norton everything works
>and if Norton is enabled but the PC is not plugged into the network it also
>works.
> When I am connected to the network the Firewall does pop up asking whether
> or not I want to allow my vb.net program to access a DNS. I have tried
> using localhost, the hardcoded IP of my machine, and my machine name (the
> usual method) without any success. It is as if Visual Studio always tries
> to resolve the machine name and cannot. VB6 programs ,dbArtisan, and SQL
> Enterprise Manager all work fine at the same time Visual Studio/VB.Net
> does not.
> Any ideas?
> Thanks,
> Mark Lewis
> mdlewis@.mdlewis.com
> P.S I am using the latest production/old Visual Studio and SQL Server on
> XP with all SP applied.
>

Cannot connect to Local SQL Server

I am having trouble connecting to my local sql server from either the Server
Explorer or vb.net code. The problem is connected to the Norton Internet
Security 2005 Firewall as when I disable Norton everything works and if
Norton is enabled but the PC is not plugged into the network it also works.
When I am connected to the network the Firewall does pop up asking whether
or not I want to allow my vb.net program to access a DNS. I have tried using
localhost, the hardcoded IP of my machine, and my machine name (the usual
method) without any success. It is as if Visual Studio always tries to
resolve the machine name and cannot. VB6 programs ,dbArtisan, and SQL
Enterprise Manager all work fine at the same time Visual Studio/VB.Net does
not.
Any ideas?
Thanks,
Mark Lewis
mdlewis@.mdlewis.com
P.S I am using the latest production/old Visual Studio and SQL Server on XP
with all SP applied.
here's an idea: configure the Norton product so that your machine can access
DNS.
-- Nick Malik [Microsoft]
MCSD, CFPS, Certified Scrummaster
http://blogs.msdn.com/nickmalik
Disclaimer: Opinions expressed in this forum are my own, and not
representative of my employer.
I do not answer questions on behalf of my employer. I'm just a
programmer helping programmers.
"Mark Lewis" <mdlewis@.mdlewis.com> wrote in message
news:u$P2swmHFHA.3336@.TK2MSFTNGP10.phx.gbl...
>I am having trouble connecting to my local sql server from either the
>Server Explorer or vb.net code. The problem is connected to the Norton
>Internet Security 2005 Firewall as when I disable Norton everything works
>and if Norton is enabled but the PC is not plugged into the network it also
>works.
> When I am connected to the network the Firewall does pop up asking whether
> or not I want to allow my vb.net program to access a DNS. I have tried
> using localhost, the hardcoded IP of my machine, and my machine name (the
> usual method) without any success. It is as if Visual Studio always tries
> to resolve the machine name and cannot. VB6 programs ,dbArtisan, and SQL
> Enterprise Manager all work fine at the same time Visual Studio/VB.Net
> does not.
> Any ideas?
> Thanks,
> Mark Lewis
> mdlewis@.mdlewis.com
> P.S I am using the latest production/old Visual Studio and SQL Server on
> XP with all SP applied.
>
|||Resubmitting this with my new MSDN Alias.
Thanks,
Mark Lewis
mdlewis@.mdlewis.com
"Mark Lewis" <mdlewis@.mdlewis.com> wrote in message
news:u$P2swmHFHA.3336@.TK2MSFTNGP10.phx.gbl...
>I am having trouble connecting to my local sql server from either the
>Server Explorer or vb.net code. The problem is connected to the Norton
>Internet Security 2005 Firewall as when I disable Norton everything works
>and if Norton is enabled but the PC is not plugged into the network it also
>works.
> When I am connected to the network the Firewall does pop up asking whether
> or not I want to allow my vb.net program to access a DNS. I have tried
> using localhost, the hardcoded IP of my machine, and my machine name (the
> usual method) without any success. It is as if Visual Studio always tries
> to resolve the machine name and cannot. VB6 programs ,dbArtisan, and SQL
> Enterprise Manager all work fine at the same time Visual Studio/VB.Net
> does not.
> Any ideas?
> Thanks,
> Mark Lewis
> mdlewis@.mdlewis.com
> P.S I am using the latest production/old Visual Studio and SQL Server on
> XP with all SP applied.
>
|||Resubmitting this with my new MSDN Alias to qualify for support.
Thanks and sorry about the double post,
Mark Lewis
mdlewis@.mdlewis.com
"Mark Lewis" <mdlewis@.mdlewis.com> wrote in message
news:u$P2swmHFHA.3336@.TK2MSFTNGP10.phx.gbl...
>I am having trouble connecting to my local sql server from either the
>Server Explorer or vb.net code. The problem is connected to the Norton
>Internet Security 2005 Firewall as when I disable Norton everything works
>and if Norton is enabled but the PC is not plugged into the network it also
>works.
> When I am connected to the network the Firewall does pop up asking whether
> or not I want to allow my vb.net program to access a DNS. I have tried
> using localhost, the hardcoded IP of my machine, and my machine name (the
> usual method) without any success. It is as if Visual Studio always tries
> to resolve the machine name and cannot. VB6 programs ,dbArtisan, and SQL
> Enterprise Manager all work fine at the same time Visual Studio/VB.Net
> does not.
> Any ideas?
> Thanks,
> Mark Lewis
> mdlewis@.mdlewis.com
> P.S I am using the latest production/old Visual Studio and SQL Server on
> XP with all SP applied.
>

cannot connect to integration services

When i try to connect to SQL 2005 integration services from object explorer i get connected (in the sense it shows in object explorer running packages stored packages ..)but when i try to exand any of these objects i get the following error

--

Failed to retrieve data for this request(Microsoft.sqlserver.smoEnum)

Additional information

The sql server specified in SSIS service configuration is not present or not available.This might occur when there is no default instance of Sql server on the computer. For more information see "config integeration services" in server 2005 books online.

Login time out expired

An error has occured while establishing a connection to the server.When connecting to the Sql server 2005, the failure may be caused by the fact that under default settings Sqlserver does not allow remote connections.

Names Pipes Provider: could not open a connection to Sql Server[2].(MsDtsSrvr)

-

i have chkd remote connection settings and other settings but cant find a way out.

kindly provide some help

Thanks in advance

This could be because you do not have a default instance of SQL Server in your machine.

Please refer to SQL Server 2005 Books online: http://msdn2.microsoft.com/en-us/library/ms137789.aspx

As it states, the default configuration file is for default instance of SQL Server in the machine. If you do not have a default instance in your machine and you want to use a named instance, then you have to modify the configuration file as described.

Please try it out and let us know if still have problems browsing the objects.|||

Thanks for the Reply ..

Thanks a lot

It worked out ...

|||

Even, I am getting the same error message after making the change in xml config file to connect named instance.

cannot connect to integration services

When i try to connect to SQL 2005 integration services from object explorer i get connected (in the sense it shows in object explorer running packages stored packages ..)but when i try to exand any of these objects i get the following error

--

Failed to retrieve data for this request(Microsoft.sqlserver.smoEnum)

Additional information

The sql server specified in SSIS service configuration is not present or not available.This might occur when there is no default instance of Sql server on the computer. For more information see "config integeration services" in server 2005 books online.

Login time out expired

An error has occured while establishing a connection to the server.When connecting to the Sql server 2005, the failure may be caused by the fact that under default settings Sqlserver does not allow remote connections.

Names Pipes Provider: could not open a connection to Sql Server[2].(MsDtsSrvr)

-

i have chkd remote connection settings and other settings but cant find a way out.

kindly provide some help

Thanks in advance

This could be because you do not have a default instance of SQL Server in your machine.

Please refer to SQL Server 2005 Books online: http://msdn2.microsoft.com/en-us/library/ms137789.aspx

As it states, the default configuration file is for default instance of SQL Server in the machine. If you do not have a default instance in your machine and you want to use a named instance, then you have to modify the configuration file as described.

Please try it out and let us know if still have problems browsing the objects.|||

Thanks for the Reply ..

Thanks a lot

It worked out ...

|||

Even, I am getting the same error message after making the change in xml config file to connect named instance.

Cannot connect to a new installed SQL Server 2000

I have installed an SQL Server 2000 Developer Edition (SP4) on a
computer that has Windows Server 2003 on it.The server is connected to
the workgroup "WORK" and has no Active Directory. Now I cannot connect
to that database server from other computers in the network. On the
server itself, I can registrate the instance from the own SQL Server
2000 and also an instance from an other SQL Server 2000 installation on
a Windows 2000 Server in the network.

The network consists of a Windows 2000 Server (with a SQL Server 2000
installation), some workstations (W2000 Pro, Win XP Pro) and the new
installed Windows Server 2003.

When I try to connect to that new database Server with Query Analyzer
from an other computer I get allways the message box with the text like
"...SQL Server doesnt exist or access denied. ConnectionOpen
(Connect())..."

Many thanks for help.
bitchangerAm 1 Mar 2006 05:16:44 -0800 schrieb bitchanger:

> I have installed an SQL Server 2000 Developer Edition (SP4) on a
> computer that has Windows Server 2003 on it.The server is connected to
> the workgroup "WORK" and has no Active Directory. Now I cannot connect
> to that database server from other computers in the network. On the
> server itself, I can registrate the instance from the own SQL Server
> 2000 and also an instance from an other SQL Server 2000 installation on
> a Windows 2000 Server in the network.
> The network consists of a Windows 2000 Server (with a SQL Server 2000
> installation), some workstations (W2000 Pro, Win XP Pro) and the new
> installed Windows Server 2003.
> When I try to connect to that new database Server with Query Analyzer
> from an other computer I get allways the message box with the text like
> "...SQL Server doesnt exist or access denied. ConnectionOpen
> (Connect())..."
> Many thanks for help.
> bitchanger

Standard installation disables network protocols like TCP/IP for server
access. If you have not defined this explicit in the setup.ini before
starting the install, you have to do this by hand, using SQL Server Client
Configuration.

bye,
Helmut