.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

how to connect to sql server 2008 developer

Posted By:      Posted Date: October 22, 2010    Points: 0   Category :ASP.Net

hi everybody,

I have a problem in connecting to database. I used to work on SQL 2005 express and it was fine so I use mdf file, but now when I siwtched to SQL Server developer I got info from other sites that mdf doesn't support SQL developer so what should I do to let visual studio 2008 pro to have connection with SQL developer 2008. Thank you for helping


this is my web.config




connectionStrings>add name="Connection" connectionString

View Complete Post

More Related Resource Links

How to connect visual web developer 2008 express edition to SQL server 2008 ??

i know its a basic question guys! please help me . i have created a login.aspx file in visual web developer .now i want to connect the username and password details to SQL database ... How do i do it .....I can see some grt genius out there, i am sure some one is kind enough to help me with this question !!! thank you .....................................

How to connect to local instance of SQL Server 2008 Management Studio Express ?


I just installed SQL Server 2008 Management studio Express on my Vista machine.

i tried connecting to local machine using :

.\sqlexpress, (local)\sqlexpress, or .\SQLExpress, MyPCNAME\SQLExpress

nothing is working, getting this error:

Cannot connect to PC-NAME\SQLEXPRESS. A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

sql server 2008 R2 Developer Edition

I am having trouble finding a place to actually purchase the developer edition of Sql Server 2008 R2. I went to CDW and they provide the ability to purchase a developer license but don't provide the actual software. Where can I actually purchase the developer edition without subscribing to MSDN? Thanks Royal

report viewer error / visual web developer 2008 / sql server 2008 / report viewer add on / win7 x64

hi, i decided to export my local site to iis today, the process wasn't smooth.   anyway. i was able to access my site, the db tables are working as i am able to create new records and retrieve them. my main problem now is with the report object. i've tried the work around found here : http://support.microsoft.com/kb/2002980.. it helped sort of. i used to have only a big page of error before i did the work around, now i am able to see half of the report (the report interface) but the contents, the field are filled with 404 errors. any idea how i can fix this??                  

SQL Server 2008 R2 Developer Edition

I've been looking to get SQL Server 2008 R2 Developer Edition since I discovered that there was going to be one.  My question is, where do i get it?  I can't find any place that references a place to buy it, or upgrade to it.  Any ideas?

Can not connect to user instance of SQL Server 2008 Express with Advance Services in Visual Studio 2

I used SQL Server 2008 Express with Advanced Services (not SQL Server 2008 Express) in Visual Studio 2010 because it is the fast and easy way to developed and managed data-driven applications with powerful built-in reporting and full-text search functionality. I received Sql Server 2008 Service Pack 1 with Windows Update. It's ok if I connect to instance of SQL Server 2008 Express with Advance Services (with SP1) through SQL Server Management, but if I try to attach a database in Server Explorer (Visual Studio 2010), I get the following error: "Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed." I'm stuck at this point. Is there a fix or a workaround? I've already tried deleting the 'C:\Users\Administrtor\AppData\Local\Microsoft\Microsoft SQL Server Data\SQLEXPRESS' directory as mentioned in other posts, with no luck. The error.log at 'C:\Users\Administrator\AppData\Local\Microsoft\Microsoft SQL Server Data\SQLEXPRESS\error.log' has the following relevant entries: 2010-09-01 14:44:10.47 Server      Error: 17156, Severity: 16, State: 1. 2010-09-01 14:44:10.47 Server      initeventlog: Could not initiate the EventLog Service for the key '3677F6D3-17C7-4F', last error code is 2. 2010-09-01 14:44:10.47 Server &

Unable to connect SQL Server 2008

Hi, I have recently installed a trial copy of SQL Server 2008 from MS web but I am not able to connect to the SQL Database Engine locally using Windows Authentication. Whenever, I tried I got the following error message: "A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)" Just to inform you, I have OS Win7.  And I want to establish local connections only on my laptop.

Testing setup of SQL Server 2008 R2 developer

The "Windows Package Manager" has the error "Operation failed with 0x80070643" and "Fatal error during installation." I have tried a few basic approaches to the installation problem, including downloading the ISO image to a different computer.  I have burned the ISO image onto four different DVDs using different media and two computers but only succeeded in verifying the burned media is Ok.  I have verified the SHA1 key with the two installation ISO images that were downloaded.  I have tried repairing the installation, but that generated a different kind of error message, "Error 1316.A network error occurred while attempting to read from the file E:\1033_ENU_LP\x64\setup\SSCERuntime_x86-enu.msi".  And then there is the "SQL Server 2008 R2 Setup has stopped working" message indicating "Windows is checking for a solution to the problem...". How fatal are the errors being encountered?  Is everything Ok?  How can I test that SQL Server 2008 R2 is fully functional?  T.69.72.

Connect to SQL Server 2008 Express

Hi Guys, I have just started a personal project for our Corporate Desktop environment to actively track our Hardware and Software Inventory.  My plan is this for starters:   1 Computer using VBScript and WMI to gather the data, store the data into SQL Server 2008 Express, and present the data using ASP.NET or Javascript. The VBScript will get a list of computers from AD under specified OUs and will run on a scheduled task.   This deployment will initially be on 1 desktop computer for now.  How do I connect to SQL Server 2008 locally using OLEDB from my vbscript?  Will this require a username/password even though it is a local connection?  If it does require a password, do you know a way to prevent the password from being stored as clear text.  Does Windows Integrated configuration on the SQL Server 2008 Express allow a passthrough of credentials from the Scheduled Task so that the password is not required from the script?  I would like it to be as secure as possible since we have financial services users and we would be under the scope of an audit if ever it was needed or requested.  Thanks guys.  :-)

Cannot Connect SQLServer 2008 with the provider SQLNCLI... Is there any SQL Server 2008 patch to sup

We have a program which developed under SQL Server 2005. In the program the provider of the connect string is hard coded as "SQLNCLI". It's ok running on SQL Server 2005. Now, for some reasons, this program must run under SQL Server 2008 (x64). But our program cannot access the SQL Server. We check the reason, found that, in SQL Server 2008, SQLNCLI is changed to SQLNCLI10, this caused our program cannot run. So I want to ask, is there any patch of SQL2008, so that the legacy program can normal access SQLserver with SQLNCLI WITHOUT rebuild a new version?  

Can't connect to SQL Server 2008 Reporting Services

When attempting to connect to SQL Server 2008 (evaluation) on Windows XP SP3, using the following url, http://servername:8080/ReportServer I receive a popup dialog box asking me for a user name and password to connect to the server.  When I enter the domain\user and password that I think it should be, it pops up two more times and then displays a blank internet explorer web page.  It is a fresh install and I believe I have everything running correctly.   Any input or guidance would be extremely appreciated.   Thank you in advance.

SQL Server 2008 Developer Edition Purchase

Where can we purchase a standalone sql server 2008 developer edition without Msdn/technet? Appreantly it is available for $37 on Microsoft Store website but does not show up in the list. http://www.microsoft.com/sqlserver/2008/en/us/pricing.aspx

SSRS 2008 - report manager: System.Net.WebException: Unable to connect to the remote server

I have an instance of Reporting Services 2008 running on Windows 2003 server.  So, the webservice URL is running on port 801, and runs fine (I can browse reports from that directory, and upload / deploy new reports and overwrite existing reports. Report manager is set to use port 800 (IIS is also on that machine running port 80).  When I attempt to connect to report manager, I get the following error, with a link to "Home" in report manager (which brings me back to the existing error page):    Unable to connect to the remote server  In the logfiles for reporting services, the following error is there: " System.Net.WebException: Unable to connect to the remote server ---> System.Net.Sockets.SocketException: No connection could be made because the target machine actively refused it.   Any ideas? Windows Firewall is NOT running on this machine.   Thanks, Chrisrjp

Cannont connect to New Installation of SQL SERVER 2008 from New Vista Ultimate machine(s)

I have a new SQL Server 2008 Development edition installation on a Newly setup Server running Windows Server 2008 Enterprise edition.  The server is mainly a file server and is not setup as a domain controller.  Since my test environment is fairly basic (server and two Vista Ultimate machines) I thought the connection through data sources on the client machines would be straight forward.  But it isn't working.  I can see the server, ping the server, etc. but when I try and connect the client through a system DNS it will not connect using SQL Server authentication using a loginId.  (since it isn't on a domain, I can't use Windows NT Authentication).   The error is SQL Error 10060 and SQL Error 17.  (connection failed and SQL Server does not exist or access denied)  Any thoughts or suggestions are appreciated. WB

Upgrading SQL Server 2008 Developer 64bit to R2 64 bit

Is there an upgrade download for Upgrading SQL Server 2008 Developer 64bit to R2 64 bit?  Where do I find it?

Can't Connect to Sql server studio 2008

Hello,   I installed the Sql Server Management Studio 2008 and made a connection but last week when i tried to connect got the error below............   A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (.Net SqlClient Data Provider)   I haven't changed anything.  I was also unsuccessful in starting the sql agent in sql configuration.  Thanks,        

Cannot uninstall SQL Server 2008 R2 Developer from Vista 32 bit SP2

Hi, I installed SQL Server 2008 R2 Developer and I now wish to go back to an earlier configuration (2008) but I cannot uninstall it. I do have Visual Studio 2008 and 2010 installed (with their instance of SQLEXPRESS), is this blocking the total removal of SQL Server 2008 or is their another issue here? The uninstall reports that all worked fine. Thanks for your help, Bex
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend