Connecting To SQL Express 2005 Via Web.Config File In Visual Studio 2003

Oct 30, 2007

Hi

 I am following a project to build a small E-Commerce site from a book I have purchased and I have having problems connecting to the SQL Database with the code supplied.

The book is Apress Beginning ASP.NET 1.1 E-Commerce

http://www.amazon.co.uk/Beginning-ASP-Net-1-1-E-Commerce-Professional/dp/1590592549/ref=sr_11_1/202-7684451-7995058?ie=UTF8&qid=1193780707&sr=11-1

 The code added to the Web.Config file is :

<configuration>

<appSettings>

<add key="ConnectionString" value="Server=(local)NetSDK;Integrated Security=True;Initial Catalog=JokePoint" />

</appSettings>

 

The connection details are in a class file called Catalog.vb and is as follows

Imports System.Data.SqlClientPublic Class Catalog

Public Shared Function GetDepartments() As SqlDataReader

'Create the connection objectDim connection As New SqlConnection(connectionString)

'Create and initialize the command objectDim command As New SqlCommand("GetDepartments", connection)

command.CommandType = CommandType.StoredProcedure

'Open the connection

connection.Open()

'Return a SqlDataReader to the calling functionReturn command.ExecuteReader(CommandBehavior.CloseConnection)

End Function

Private Shared ReadOnly Property connectionString() As String

GetReturn ConfigurationSettings.AppSettings("ConnectionString")

End GetEnd Property

End Class

 The error is.....
Cannot open database "JokePoint" requested by the login. The login failed. Login failed for user 'MachineNameASPNET'. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Cannot open database "JokePoint" requested by the login. The login failed. Login failed for user 'MachineNameASPNET'.

Source Error:







Line 15: 'Open the connection
Line 16:
Line 17: connection.Open()
Line 18:
Line 19: 'Return a SqlDataReader to the calling function


Source File: C:MyCommerceSiteJokePointBusinessObjectsCatalog.vb    Line: 17

Stack Trace:







[SqlException: Cannot open database "JokePoint" requested by the login. The login failed.
Login failed for user 'MachineNameASPNET'.]
System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction)
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction)
System.Data.SqlClient.SqlConnection.Open()
JokePoint.Catalog.GetDepartments() in C:MyCommerceSiteJokePointBusinessObjectsCatalog.vb:17
JokePoint.DepartmentsList.Page_Load(Object sender, EventArgs e) in C:MyCommerceSiteJokePointUserControlsDepartmentsList.ascx.vb:44
System.Web.UI.Control.OnLoad(EventArgs e)
System.Web.UI.Control.LoadRecursive()
System.Web.UI.Control.LoadRecursive()
System.Web.UI.Control.LoadRecursive()
System.Web.UI.Page.ProcessRequestMain()


The connection tests ok in Visual Studio 2003. All permissions are set using SQL Management Studio Express 2005.

The book is using SQL 2000, I have been trying different connection syntax's in the Web.Config file all day and now I have a big headache. I know its something simple, can anyone please advise ?

Thanks in advance.

 

Mark

View 3 Replies


ADVERTISEMENT

SQL 2005 Express And Visual Studio 2003 - Connecting

Jul 20, 2006

I have Visual Studio 2003 and had used it successfully with MSDE. I recently upgraded to SQL 2005 Express and cannot seem to connect to the SQL server. it appears in the list of servers on localhost, but when I try to create a new database it tells me that it "cannot create databases on this server." It will not even open up any existing databases.

I have .NET 2.0 installed. I uninstalled SQL and reinstalled it, but nothing seems to help. I feel I must be missing something, but do not know what.

I no longer have the MSDE installation files, so I hope I can get Studio to talk to SQL Express.

Any help is appreciated.

View 22 Replies View Related

Connecting Visual Studio 2003 To SQL Server Express 2005 Edition

Jan 11, 2006

I was wondering if it is possible to connect the SQL Server 2005 Express Version to Visual Studio 2003.If its possible , how can it be done?Cos i seem to have an error if i do so.

View 4 Replies View Related

SQL Express 2005 With Visual Studio 2003

Jun 2, 2006

I am just starting to work with Visual Studio and SQL. I have Visual Studion 2003 with .net Framework 1.1. I want to download the SQL 2005 Express version and it requires the upgrade to .NET Framework 2.0

Will this affect my Visual Studio 2003? And can I use SQL 2005 with Visual Studio 2003?

Any help would be appreciated.

Thanks,

View 1 Replies View Related

Use SQL Server Express 2005 With Visual Studio 2003

Jul 16, 2007

Hi, is it possible to use SQL server express 2005 with visual studio 2003?

i've some problems...

Thanks

View 4 Replies View Related

Can I Use MS SQL Server Express 2005 In Visual Studio 2003?

Aug 3, 2007




I have been experiencing troubles since I was decided to install SQL Server Expr 2005 in my PC, first I needed to remove the .NET framework 1.1 in my computer because it is suggested before installing sql server expr 2k5 that cause my vs.net 2003 to stop loading because sql express runs in .NET framework 2.0 and vs.net 2003 is in .Net Framework 1.1 then what I did is to install .Net Framework 1.1 in my PC together with .Net Framework 2.0 and my vs.net started runnning again.

My problem now is when I try to connect to a database using Data Link Properties in the Server Explorer it says "[DBNETLIB][ConnectionOpen](Connect()).]Sql server does not exist or access denied." how could this happen if I can see the sql server in the Server Explorer in my VS.net environment?

Please somebody help me I am just learning to this language and I think I cannot proceed to the next few chapters remaining because of this.

Thank you very much!

View 5 Replies View Related

Whether SQL Server 2005 Express Edition Can Work With Visual Studio 2003 (Ver 1.1)

Mar 3, 2006

We are new to SQL Server 2005 Express Edition. We are going to develope a solution for one of our client and we have to decide on which database to use for the solution. Client wanted to have a low cost solution. Thus we were not in a position to push them for SQL Sever 2000.

In the process, we also thought of having MySQL as one of the option. Another option we have is to use SQL Server 2005 Express Edition.

We wanted to know if SQL Server 2005 Express Edition can be used with Visual Studion 2003 (Ver 1.1) or it can only be used with Visual Studio 2005 (Ver 2.0)?

Hope to get feedback soon.

Regards

Sanjeev



View 1 Replies View Related

Can Visual Studio 2005 BI Co-exist With Visual Studio 2003?

Jan 19, 2006

I ask because I'm still looking for the source of interface problems I have in using the SSIS designer.

View 4 Replies View Related

Visual Studio 2003 And SQL Server Express

Apr 14, 2006

I'm attempting to connect to my SQL Server Express instance through Visual Studio 2003. When I go to Data Connections, I choose the Microsoft OLE DB Provider for SQL Server, then fill in all the parameters for my server (server name, username, password, database). When I click "Test Connection" it goes through successfully. When I click "Ok" to create the Data Connection, it fails saying that the username and password should be checked. I changed the username and password to the "sa" account I created when I installed SQL Server Express, and got the same successful connection test, but failure when it tries to create the connection. Any suggestions? Thanks!

View 3 Replies View Related

SQL/CLR Debugging Hangs On Visual Studio 2003 And SQL 2005

Feb 5, 2008

I am unable to debug code from a SQL Database Project using the CLR. After VS 2005 does the auto-attaching to the SQL server, VS hangs until I tell it to stop debugging. Many others have reported this as a similar problem, however this only seems to affect me when I€™m connecting to specific servers. Specifically it seems to be remote connections. When I attempt to connect to my SQL 2005 Developer Edition €œlocally€? I get right through and can debug.
From my VS output window:




Auto-attach to process '[1688] [SQL] gx620-eric' on machine 'gx620-eric' succeeded.

Debugging script from project script file.



testing

No rows affected.

(0 row(s) returned)

Finished running sp_executesql.

The thread 'gx620-eric [59]' (0x1730) has exited with code 0 (0x0).

The thread 'gx620-eric [59]' (0x1730) has exited with code 0 (0x0).

The thread 'gx620-eric [59]' (0x1730) has exited with code 0 (0x0).

The thread 'gx620-eric [59]' (0x1730) has exited with code 0 (0x0).

The program '[1688] [SQL] gx620-eric: gx620-eric' has exited with code 0 (0x0).




When I attempt to connect to a remote server running Enterprise Edition, it hangs after a successful attach.




Auto-attach to process '[1856] [SQL] virtual2003eric' on machine 'virtual2003eric' succeeded.


Sometimes after countless attempts, I am able to get this to work, but lately I have had no success. As far as the SQL Server side, enabling and disabling the CLR through the Surface Area Configuration seems to be the only place to do anything relative to the CLR inside SQL server.


I have firewalls disabled. All SQL Servers presently have both SQL 2005 SP2 and Visual Studio 2005 SP1 installed.



I€™ve tried restarting servers and services, checking and un-checking €œAllow SQL/CLR Debugging€? and those steps did not work for me.



Does anyone have any insight on this one? Any ideas on how I can further debug this one?



Thanks.

Eric

View 4 Replies View Related

Connect To SQL Server 2005 From Visual Studio 2003

Jul 21, 2006

hello all,

i have SQL Server 2005 installed on a network computer and want to access it through code in asp.net. I am using visual studio 2003.

I have porvided this connection string to connect to that Sql Server 2005 Express instance but failed:

data source=mynetworkstystemSQLEXPRESS;database=MobMatiLogs;User Id=sa;password=mobmasti786

But I get the error:

SQL Server does not exist or access denied.

Anyone please help me!

Thanks in advance

View 4 Replies View Related

DB Connection From Visual Studio 2003 To Sql Server 2005

Jun 1, 2007

I have one computer running Visual Studio 2003, and another running SQL Server 2005. I am trying (unsuccessfully) to add a connection to a sqlDataAdapter from an application in the Visual Studio 2003 computer to the db on the SQL 2005 machine.

If I go to the machine running sql 2005, where I am running visual Studio 2005, I can create this connection with no problems.



Is there a way fromvisual Studio 2003 to create a sqlDataAdapter with a connection to SQL 2005?



View 3 Replies View Related

Visual Studio Database File And SQL Server Management Studio Express Question

Mar 17, 2007

I have a database in my "App_Data" folder of my visual studio project.  I can view it fine in Visual Studio's built-in tools for managing a database attached to a solution.  However i recently started playing around with the SQL Server Management Studio Express program.  When i attach my database to Management Studio, and try to run my program it crashes.  I think it might be a permissions error?!? When i detatch it and reattach it in visual studio it runs fine again.   Any suggestions? ThanksJason 

View 1 Replies View Related

Can I Use Reporting Services 2005 Reports On An ASP.NET Page Created With Visual Studio 2003?

Oct 15, 2007

Hello,

I've seen this question floating around, but I have not been able to find a definitive answer.

Can this be done, and if so, what do I need to install into Visual Studio 2003?

Thank you.

-Gumbatman

View 5 Replies View Related

Help Me For Connecting SQL Server 2000 With ASP.NET Using Visual Studio 2005

Dec 27, 2007

hi
I m rishabh
Can some1 hel me with the connection of SQl server 2000 and visual studio 2005 for the ASP.NET web application.
the Express edition was instaled on my computer with the visual studio installation but later i hav uninstalled the express edition and have now installed the 2000 sql server, but could not able to connect ..
can some1 please hel me out with this...
thanking you
rishabh

View 1 Replies View Related

SQL Server 2000 Connecting To ASP.NET(visual Studio 2005)

Dec 28, 2007

hello guys ..
can some1 could help me the connection bw the Visual Studio 2005 and the SQL Express Edition which is there provided by the Setup only....
i am a bignner and i am doing it by my one with a reference of book called APRESS- Beginning ASP.NET 2 in c#.
i hav reached to the data access part of the book , almost half completed but i got stuck here...
 
 the pubs database was not inbuilt i have made it by right-click on the "DataConnection" in the "Server Explorer" and making the new database......named "pubs"
the code i hav wrote in the "Default.aspx.cs" isstring connectionString="Data Source=localhost\SQLEXPRESS;Initial Catalog=pubs;";SqlConnection myConnection = new SqlConnection(connectionString);
 
try
{
myConnection.Open();Label1.Text = "server version" + myConnection.ServerVersion;Label2.Text = "connection is :" + myConnection.State.ToString();
}catch (Exception err)
{Label1.Text = "err reading the DataBase ";
Label1.Text += err.Message;
}
finally
{
myConnection.Close();Label1.Text += "now the connection is :";
Label1.Text += myConnection.State.ToString();
}
 
 
 
on debuging the above code the error i m geting is :
err reading the DataBase             (print statement)
Login failed for user ''. The user is not associated with a trusted SQL Server connection     (error)
.now the connection is :Closed            (print statement)
 

View 4 Replies View Related

Connecting SQL Server 2005 Dev Edition To Visual Studio 2005

Apr 14, 2008



ok so i have set up SQL server 2005 on a Windows server 2003 machine. I am trying to connect to it via ODBC and/or Visual Studio 2005 on a computer running off the same switch. I have set SQL server to accept remote connections and named pipes as well as had the port unblocked. when i try and connect to it via Vista ODBC wizard or visual studio wizard it says that the server is not there or access is denied.

The server is set up for SQL authentication and i am 100% pos that the username/password i am using is correct. i am at a total loss as to what to do to get my vista machine to talk to that SQL server.

View 1 Replies View Related

SQL Server 2005 - Studio Express Vs. Visual Studio 2005 Install

May 5, 2006

I'm very confused.  I installed Visual Studio 2005 and thought I understood that SQL Server 2005 came with it, but it appears that it's SQL Server 2005 - Express.  Can anyone tell me what I need to do in order to get Data Transformation Services loaded or the equivalent of DTS in SQL Express? 
 
 

View 1 Replies View Related

Connecting To SQL Server 2005 Express Edition From VS 2003?

Apr 13, 2006

Hi,

How do I connect to Sql Server 2005 express from Visual Basic. Net 2003 ?

Kumar

View 4 Replies View Related

Connecting Visual Web Designer To SQL Server 2005 Express

May 21, 2008

Hi all!On a server computer, I have SQL server 2005 express edition installed, and am using that for my web server, but I want to develop the applications in Visual Web Developer on a remote machine on my LAN. This means I will have to connect VWD to the remote SQL server, to work with the databases.How do you connect VWD to a Remote SQL server?Thanks!

View 3 Replies View Related

Sql Express SP2 And Visual Studio 2005

Jan 11, 2007

Will the SQL Express SP2 update the Installer package that comes with Visual Studio 2005 so that SQL Express SP2 is included with a ClickOnce or MSI based installer?

Including SP2 on Windows Update is a step in the right direction, but I (and I assume others) really hate the idea of burdening our users with the additional step of obtaining the SP2 update immediately after installing our application. This is especially cumbersome if they are using dial-up Internet connections which, unfortunately, many of our customers continue to use.

Thanks,
Travis

View 12 Replies View Related

Connecting To SQL Server 2005 From Visual C# 2005 Express Edition

Sep 29, 2006

I had SQL Server Express Edition installed. I then uninstalled both it and Visual C#. I then installed SQL Server 2005 Developer's Edition and reinstalled Visual C# -- both on the same machine. I can connect to SQL Server 2005 using SQL Server Management Studio. However, Visual C# is a different story. When I try to add a new Data Connection, it defaults the data source to .SQLEXPRESS, which is no longer on my machine. I can select .MSSQLSERVER, but when I click on either OK or Test Connection, I time out with an error message -- error 25 - Connection string is not valid. The connection string that is shown at the bottom of the Advanced dialog box is -- Data Source=.MSSQLSERVER;AttachDbFilename=E:InventoryDataInventory_Data.MDF;Integrated Security=True;Connect Timeout=30;User Instance=True

View 12 Replies View Related

Simple Examples Of SQLCLR By Connecting To SQL Express User Instances In Management Studio Via VB 2005 Express

Sep 28, 2007

Hi all,
I want to do SQLCLR by Connecting to SQL Express User Instances in Management Studio via VB 2005 Express and I have read the following articles and books:
(i) Connecting to SQL Express User Instances in Management Studio in http://blogs.msdn.com/sqlexpress/archive/2006/11/22/connecting-to-sql-express-user-insta...
(ii) Managing SQL Server Express with SQL Server 2005 Management Studio Express Edition in http://www.microsoft.com/technet/sql/2005/mgsqlexpwssmse.mspx
(iii) Chapter 16 - Going Beyand Transact-SQL: Using the SQL Common Language Rutime (SQLCLR) in Microsoft SQL Server 2005 Express Edition for Dummies
(iv) Chapter 21 - Working with the Common Language Runtime in Microsft SQL Server 2005 Programming for Dummies
(v) Chapter 4 - Introduction to Common Language Runtime (CLR) Integration in Programming SQL Server 2005 by Bill Hamilton.
I want to create an SQLCLR project "HelloWorld" by Connecting to SQL Express User Instances in Management Studio via VB 2005 Express. But I am still not sure how to get it started, because I do not understand the following things:
(1) Pipe Name for a User Instance, (2) Enabling (or Disabling) the CLR by using Transact-SQL, (3) Creating a Transact-SQL script, (4) Creating an Assembly, (5) Creating a backup device, etc. I need to see some simple examples of SQLCLR by Connecting to SQL Express User Instances in Management Studio via VB 2005 Express. Please help and tell me where in the websites I can find them.

Thanks in advance,
Scott Chang

View 5 Replies View Related

Using Visual Studio 2003 With Sql Server 2000 And Planning To Switch To Sql Server 2005

Aug 24, 2006

We have a project already developed iusing VS 2003 Enterprise architect edition using sql server 2000(have lots of table and stored procs etc.)
Now planning to switch to Sql server 2005 are there any issues associated with the switch.
 
I mean front end programming wise asp.net and vb.net front end codes do they work straight away or need to make any changes to all the front end codes, we are using datasets, data readers calling stored procs and also using lot of hash tables and XML object to make bulk loads to sql server via sqlxml3.0 sp3.
Please help thank you very much for the information.

View 1 Replies View Related

How To Slipstream Sql Server 2005 Express SP1 Into Visual Studio 2005 Setup?

Jul 18, 2006

Hello, I would like to know if anyone here has any information on how to change the default version of SQL Server 2005 Express which ships with Visual Studio 2005 to the new SQL 2005 Express SERVICE PACK 1?

I see a file under disc:vswcuSSESQLEXPR.exe I am wondering if changing that file with the new one from Microsoft Download Center will do it...

There's another file under that folder named sqlexpr32.exe I am wondering what it's for?

Thanks in advance.

View 1 Replies View Related

How To Slipstream Sql Server 2005 Express SP1 Into Visual Studio 2005 Setup?

Jul 18, 2006

Hello, I would like to know if anyone here has any information on how to change the default version of SQL Server 2005 Express which ships with Visual Studio 2005 to the new SQL 2005 Express SERVICE PACK 1?

I see a file under disc:vswcuSSESQLEXPR.exe I am wondering if changing that file with the new one from Microsoft Download Center will do it...

There's another file under that folder named sqlexpr32.exe I am wondering what it's for?

Thanks in advance.

View 2 Replies View Related

Visual Studio 2005 Unable To Connect To SQL Server Express 2005

May 26, 2008

Hi,
I have VS Pro 2005 and SQL Server Express 2005 installed on an XP Pro machine. When using VS 2005, in the 'Server Explorer' window I can see and attach to two SQL Server databases that I have set-up. But if I attempt to access the same databases from withn the 'Solution Explorer' window I get the following dialog box message,

"
Required Component Missing (Dialog box heading)

Connections to SQL Server Files (*.mdf) require SQL Server Express to function properly. Please verify the installation of the component or download from the URL: http://go.microsoft.com/fwlink/?LinkId=49251
"

I have uninstalled and then reinstalled both VS 2005 and SQL Server Express twice but it has helped.

I don't understand why I'm getting this error because all of the server configuration tools and connection utilities seem to work fine but VS say's that SQL Server Express is not installed.


Thanks,

CLN

P.S.
I had another application that required MSDE 2000A to be installed. When I removed the other application I also removed MSDE 2000A and that's when the problem began.

View 3 Replies View Related

Visual Studio 2005 Bootstrap Package For SQL Server 2005 Express Edition With Advanced Services SP2

Feb 15, 2008

Hi there,

Anyone know how I can replace (or download) the sqlexpr32.exe bootstrap package with the advanced services SP2 edition of SQL 2005 express ?

Pieter

View 9 Replies View Related

Visual Studio 2005 Command Prompt Missing From SQL Server 2005 Express Toolkit Install

May 10, 2006

The program shortcut "Visual Studio 2005 Command Prompt" seems to be mising from the "Visual Studio 2005 Command Prompt" Start menu added by the current Microsoft SQL Server 2005 Express Edition Toolkit. Where is it? How to workaround?

I am trying to do Download details SQL Server 2005 Samples and Sample Databases (April 2006) -> GettingStartedWithSQLSamples.htm which says "a. Open a Microsoft Visual Studio 2005 command prompt. Click Start, point to All Programs, point to Microsoft Visual Studio 2005, point to Visual Studio Tools, and then click Visual Studio 2005 Command Prompt." but I can find no such command prompt within "Visual Studio Tools", only "Visual Studio 2005 Remote Debugger{, Configuration Wizard}".

What's wrong? How to fix or workaround? I'd install .NET SDK 2.0 to get it's Command Prompt but that's about 570MB merely for a command prompt!

Thanks for your help, -Mike Parker

View 1 Replies View Related

SQL Server 2005 Express And Visual Studio 2005 Standard

Jul 9, 2006

Hi everyone,I am trying to connect to SQL Server 2005 Express with Advanced Services from Visual Studio 2005 Standard Edition.  I have SQL Server 2005 Standard Edition but it took up so much space and resources on my computer that I didn't want to put it back on there.  So I put the SQL Express on there and while the Management Studio application connects just fine, VS 2005 will not.  Oddly enough, VS 2005 connected just fine to SQL 2005 Standard.  I have enabled shared memory, named pipes and TCP/IP.  I have set up SQL Express to accept remote connections on named pipes and TCP/IP.  And I have tried running SQL Express as the Local System Account, as a Local Service and as a Network Service.  Nothing.  I have tried feeding the Server Name is the Data Connections dialog in Visual Studio my SQL Express instance as (local)/SQLEXPRESS, localhost/SQLEXPRESS, and {computername}/SQLEXPRESS where {computername} is the name of my local computer which SQL Express is (allegedly) running on.  And I cannot get the list of databases on that server.There is probably something very simple that I have left out.  Can anyone see what it is?Thanks!

View 2 Replies View Related

SQL Server 2005 Express Connectivity With Visual Studio.NET 2005

Dec 5, 2007

Hello
I'm having a problem with the server connection and my C# code. The code executes alright but no data is entered into the database behind it.  I'm pasting the connection code over here as well. The sql commands are used in the code. I think I used the sql server mobile edition which is installed along with visual studio.net 2005. Anyone know what's wrong, and can help me out? Thanks in advance.public static void storeInDb(string trackName, string artist, string albumTitle, string year, string path, uint[] fp)
{
string connStr="Data Source=.\SQLEXPRESS;AttachDbFilename='"+path+"\Data\ACI.mdf';Integrated Security=True;User Instance=True";SqlConnection conn = new SqlConnection(connStr);
conn.Open();string sql = "INSERT INTO Clip(Song, Artist, Album, Year) VALUES('" + trackName;sql = sql + "','" + artist + "','" + albumTitle + "','" + year + "')";
 SqlCommand cmd = new SqlCommand(sql, conn);
cmd.ExecuteNonQuery();
 sql="SELECT max(ClipID) FROM Clip";
cmd = new SqlCommand(sql, conn);int id = Int32.Parse(cmd.ExecuteScalar().ToString());for (int i = 0; i < fp.Length; i++)
{
sql="INSERT INTO Hash VALUES ("+id+","+(i+1)+","+(int)fp[i]+")";cmd = new SqlCommand(sql, conn);
cmd.ExecuteNonQuery();
}
conn.Close();
}

View 1 Replies View Related

SQL 2005 Express Toolkit Problem With Visual Studio 2005

Sep 23, 2006

I have windows XP box, installed MS Visual Studio 2005 without SQL 2005 express.After this I have installed SQL 2005 Express edition and then SQL 2005 client toolkit.

Now when I open "SQL Server Business Intelligence Development Studio", it gives message missing shortcut and searches for devenv.exe file. That is the problem, I dont know where is problem..??

Please anybody help me............???



Cheers,

Gurpreet

View 4 Replies View Related

Error Connecting To The Sqlserver Express Edition From Visual Web Developer 2005

Dec 19, 2007

hello eveyone..i have just downloaded and installed the visaul web developer 2005 express edition and sqlserver 2005 express edition.On top of that i even downloaded and installed the northwind database.But my problem is when i am connecting to the northwind database by clicking toos menu>connect to the database>choose datasource>new connection>..i have provided it with the required information..but as soon as i press "Test Connection" button the following error box displays.. "an error has occured while establishing a connection to the server.when connecting to the sql server2005,this failure may be caused by the fact that under default settings sql server doestnot allow remote connections.(provider:Named piped providers,error:40-couldnot open a connection to sqlserver.)" i have no idea whats is all about..can anyone get me pass this error..    

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved