CodeVerge.Net Beta


   Explore    Item Entry   Register  Login  
Microsoft News
Asp.Net Forums
IBM Software
Borland Forums
Adobe Forums
Novell Forums

ASP.NET Web Hosting – 3 Months Free!



Zone: > NEWSGROUP > Asp.Net Forum > visual_studio.visual_studio_2005 Tags:
Item Type: NewsGroup Date Entered: 1/11/2006 12:36:31 PM Date Modified: Subscribers: 0 Subscribe Alert
Rate It:
(NR, 0)
XPoints: N/A Replies: 4 Views: 15 Favorited: 0 Favorite
Can Reply:  No Members Can Edit: No Online: Yes
5 Items, 1 Pages 1 |< << Go >> >|
Pztydr
Asp.Net User
Connection to SQL Express from VS20051/11/2006 12:36:31 PM

0/0

Hi,
    Have recently installed Visual Studio 2005(Pro) and SQLExpress along with the SQL Server Management Studio Express.

My problem is that I can connect to SQL Server using the Studio Express but I cannot connect to the SQL Server through Visual Studio. I can see the Server name in the Server dropdown list but once selected and using Windows Authentication I cannot see any Database tables in the dropdown, the create dataconnection returns an error telling me that it cannot connect to the SQL server. It says something about remote connections.

I have run the Surface configuration and allowed both remote and local connections using TCPIP and Name pipes. Even tried it with just TCPIP but no go.

Is it supposed to be so difficult??

Regards..
Peter.

kevbo
Asp.Net User
Re: Connection to SQL Express from VS20051/11/2006 5:00:55 PM

0/0

do you have security and permission set up for your user?

Pztydr
Asp.Net User
Re: Connection to SQL Express from VS20051/11/2006 9:16:42 PM

0/0

Hi,

    I setup access for ASPNET as you would normally under SQL2000, is there other permissions I need to setup???

 

Regards..

Peter.

lano
Asp.Net User
Re: Connection to SQL Express from VS20051/12/2006 10:20:17 PM

0/0

Hi,

could it be your database added in the separate instance not the main instance?  Could you try couple thing?

Go to the sql express machine, down load the SSEUtil.exe from the following URL

(http://www.microsoft.com/downloads/details.aspx?FamilyID=fa87e828-173f-472e-a85c-27ed01cf6b02&DisplayLang=en)

On the command window, type in

> SSEUtil -l -m

can you see the database name you are looking for listed?  If not, you need to attach it to the main instance by

> SSEUtil -d [path where your mdf located]

and reattached to the main instance by

> SSEUtil -a [path where your mdf located] -m

Hope that helps,

Lan

 

Pztydr
Asp.Net User
Re: Connection to SQL Express from VS20051/12/2006 10:55:14 PM

0/0

Lan,

     Thanks.. I ended up working out my problem and it as that i wasn't specifying the instance. I was just supplying the machine name and not the MachineName/Instance once I did this I had no problem.

In the past i have never installed SQL with an instance rather let the machine name be the instance if you know waht I mean. When installing SQLExpress it automatically creates an instance.

 

Regards..

Peter.

5 Items, 1 Pages 1 |< << Go >> >|


Free Download:

Books:
Beginning SQL Server 2005 Express Database Applications: With Visual Basic Express and Visual Web Developer Express from Novice to Professional Authors: Rick Dobson, Pages: 596, Published: 2005
Professional Visual Studio 2005 Authors: Andrew Parsons, Nick Randolph, Pages: 869, Published: 2006
SQL Server 2005 Bible Authors: Paul Nielsen, Pages: 1293, Published: 2006
Microsoft SQL Server 2005 Express Edition For Dummies Authors: Robert Schneider, Stephen Giles, Pages: 408, Published: 2006
Pro Visual Studio 2005 Team System Authors: Jeff Levinson, David Nelson, Pages: 515, Published: 2006
Mastering Web Development with Microsoft Visual Studio 2005 Authors: John Paul Mueller, Pages: 822, Published: 2005
Learning WCF: Master Windows Communication Foundation and Soa Fundamentals Authors: Michele Leroux Bustamante, Pages: 582, Published: 2007
Practical .NET 2.0 Networking Projects Authors: Wei-Meng Lee, Pages: 272, Published: 2007
Beginning Visual C# 2005 Authors: Karli Watson, Christian Nagel, Jacob Hammer Pedersen, Jon D. Reid, Morgan Skinner, Eric White, Pages: 1062, Published: 2006
Pro WF: Windows Workflow in .NET 3.0 Authors: Bruce Bukovics, Pages: 709, Published: 2007

Web:
Connection to SQL Express from VS2005 - ASP.NET Forums Re: Connection to SQL Express from VS2005. 01-11-2006, 12:00 PM. Contact ... Re: Connection to SQL Express from VS2005. 01-11-2006, 4:16 PM ...
Can't connect to SQL Server(SQL Express) in VS 2005 - .NET VB Can't connect to SQL Server(SQL Express) in VS 2005. Get answers to your questions in our .NET VB forum.
SQL Server Express WebLog : Connecting to SQL Express User ... We need to connect to SQL Express instance remotely from another server. ... fine when accessed through IIS 7.0 User administration, SSEUtil, and VS2005 ...
CodeProject: Connecting to Database SQL Express 2005 with VS 2005 ... Aug 2, 2006 ... Connecting to SQL Express Manualy; Author: efero; Section: Database; Chapter: Database.
Connection Problem with SQL server 2005 Express and VS 2005 ... Connection Problem with SQL server 2005 Express and VS 2005 express edition. Asked by texpert on 8/21/2006 12:40:00 PM ...
Connecting to Microsoft SQL Server 2008 from Microsoft Visual ... Introduction. Connecting Existing Applications to SQL Server 2008. Visual Studio 2005. Visual Studio 2008. Visual Studio Express Editions. Conclusion ...
Express Essentials: The Code Connection Between Visual Studio 2005 ... Nov 5, 2007 ... "Connecting Visual Studio 2005 to SQL Server Express" (www.sqlmag.com/Article/ ArticleID/97216 ) and "Connecting Visual Studio 2005 to SQL ...
Problem connecting to SQL Server 2000 using VS 2005 (Please help!) Hello, I have VS 2005 with SQL Server Express in the same machine, but need to connect to a remote SQL Server 2000. I'm getting this error: ...
Connection to SQL Express from VS2005 - ASP.NET Forums Have recently installed Visual Studio 2005(Pro) and SQLExpress along with the SQL Server Management Studio Express. My problem is that I can connect to SQL ...
Login failed - connecting to Sql-Server Express 2005 : Cannot open ... I am using Visual Studio 2005, Sql Server Express 2005, and Windows Vista ..... If i close the connection in VS 2005, the app can connect to the database. ...




Search This Site:










visual studia 2005 and linkq

converting asp.net 2.0 into asp.net 1.1 using vs 2005

visual studio 2005 toolbox utility

where is "data form wizard" vs 2005

problems usings remote iis option

use custom made file template?

help - vs2005 duplicates style/css entries

web deployment projects

how do you create a multiple word search box to return rows from a sql database in asp.net 2.0

designer window context menu

refactoring

to scott guthrie: visual studio 2005 web application projects (beta preview)

changing the default language of the dataset designer class code

how to delete a bogus file name from my project.

reading from a drop-down list, in vs 2005

cant open dataset editor.

<asp:checkboxfield /> in an <asp:gridview /> object

dataset bug??

how to launch excel application

can't add items to toolbox of vs2005

vs 2005 with sp1 crashes when adding a reference

asp.net vs asp.net 2.0

strange rebuild problem

deleting files in web sites when working with sourcesafe

web user control is defined in multiple places. compiler error.

errors not being detected on build

i don't get the file name, line number etc. in build exceptions

share resouces across projects

cannot create queries on datatable in vs dataset designer

adding control to toolbox

  Privacy | Contact Us
All Times Are GMT