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


Top 5 Contributors of the Month
Easy Web
Imran Ghani
Post New Web Links

SQL Authentication within SQLExpress Not Able to Connect to SQL User from Visual Studio?

Posted By:      Posted Date: October 17, 2010    Points: 0   Category :Sql Server
 

I detached a database from sql server 2005 to an mdf file. I am able to logon to this mdf file from server management studio within sqlexpress instance using the sql user/pwd with no problem.

Within Visual Studio however, if I try to connect useing  the Server Explorer, I receive the error:
"Failed to generate a user instance of SQL Server. Only an integrated connection can generate a user instance. The connection will be closed."

I went into Advanced Properties and changed User Instance to False, and then get this error:
"Create Database Permission denied in database "master". An attempt to attach an auto-named database for file "c:\......mdf" failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

I opened the database again in management studio and detached it from sqlexpress, but still get same errors.


This issue is similar to the one posted here
http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/ec9f1ded-1b9e-476d-acd9-77caf79a47b4/

but unfortunately for me, none of the suggestions in that po


View Complete Post


More Related Resource Links

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 &

Failed to generate a user instance of SQL Server 2008 Express with Advance Services in Visual Studio

  
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 to Visual Studio's Localhost Web Server

  
I've been running Visual Studio 2005 for about three weeks now and everything has worked just fine. Now all of the sudden I'm getting this error "Unable to connect to Visual Studio's Localhost Web Server" Any ideas how I can fix it?

unable to connect to visual studio's localhost web server

  
Hello, I created a simple web page in Microsoft Visual Web Developer 2005 Express Edition.  Then I pressed Ctrl/F5. Build succeeded. Next I reseived an error message "unable to connect to visual studio's localhost web server". Does anybody know why?  

How to connect to MOSS server using visual studio from client side

  
Dear All We are having one moss development environment and we are having many developers working on it.Since all the developers cannot work at a time,we are facing difficulties while developing sharepoint components. Is there any way to connect to sharepoint server from visual studio(from client side) so that we can compile our sharepoint components from client side and deploy later to the server? Any help on this would be much appreciated? Thanks Karthik S

Visual Studio won't connect to SQL 2000

  

Can VS 2010 connect to a SQL 2000 database?

I get this error while using the Data/Connect and SQL Server 2008 R2 comes up.


"The connection failed because this instance of SQL Server is not supported. The Editor cannot connect to SQL Server 2000 or earlier

versions."


Our production server is on SQL 2000


Can't connect to database after installing visual studio 2008 sp1

  

Hi, it looks like visual studio 2008 sp1 broke something in katmai managment studio - now when i try conneect to my db server, i'm getting error message below(no problems though connecting to the same server with sql managment studio 2005):

 

 

Error connecting to 'XXX\SQL2005'.

===================================

Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc.EnumeratorCore)

------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476

------------------------------
Program Location:

   at Microsoft.SqlServer.Management.Sdk.Sfc.Enumerator.Process(Object connectionInfo, Request request)
   at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.SupportedServers.GetSqlEngineEdition(SqlOlapConnectionInfoBase connectionInfo)
   at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.SupportedServers.GetHierarchyBuilder(SqlOlapConnectionInfoBase connectionInfo)
   at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.GetObjec

SQL Server 2008 R2 Developer with Visual Studio 2010 Pro always defaults using SQLEXPRESS

  

I had un-installed SQL Server 2008 Express that came with the Visual Studio 2010 Pro.

I had installed SQL Server 2008 R2 Developer, and Im able to connect through the Management Studio and Visual Studio itself.

The problem is: whenever I create a new ASP.NET Web Application, the web.config always defaults using SQLEXPRESS.

How can I change this within Visual Studio 2010 so that the web.config defaults to the new database SQL Server 2008 R2 Developer that I installed?


Cannot create database diagrams for sqlexpress .mdf file in Visual studio server explorer

  

Hello!

I've look around the forums but I can't get the solution for my problem. I've installed Visual studio 2010 with sqlexpress edition. Then I have renamed my computer. After renaming my computer I've deleted the directory C:\Users\uporabnik\AppData\Local\Microsoft\Microsoft SQL Server Data\SQLEXPRESS. After restart, I have started VS2010, open Server explorer and I've added the connection to a new database. I've been able to add new tabels, bu when I've tried to add a diagram, it didn't work. In properties window od the database I saw, the the database owner was oldComputerName\username not newComputerName\userName. In sql server management studio I've reanmed the user oldComputerName\userName to newComputerName\userName. After attaching the database it worked fine.

I've returned to Visual studio 2010. When creating new database, the owner of new database is oldComputerName\userName. The next tip was renaming the  SQLServerMSSQLUser$ComputerName$SQLEXPRESS(and other names with sql...) in Local Users and gorups in Mange My computer. After restarting the compter I've got the same result. When creating new .mdf file in server explorer of visual studio, the database owner is oldComputerName\userName.<

Custom list for anonymous user submission & Visual Studio Sequentional workflow on that custom list.

  

I have couple of question to experts here in sharepoint.

I created a custom list & given add, view anonymous access in our intranet site.

then i went to our public site & submitted the item i get error saying " An unexpected error has occured" instead of showing the allitem.aspx for custom list.

But item is submitted in sharepoint custom list. 

i collected following infomation in the event log

General                        8nca Verbose  Application error when access /testsite/Lists/test/NewForm.aspx, Error=Server Out Of Memory  There is no memory on the server to run your program. Please contact your administrator with this problem.   at Microsoft.SharePoint.Library.SPRequestInternalClass.AddOrUpdateItem(String bstrUrl, String bstrListName, Boolean bAdd, Boolean bSystemUpdate, Boolean bPreserveItemVersion, Boolean bUpdateNoVersion, Int32& plID, String& pbstrGuid, Guid pbstrNewDocId, Boolean bHasNewDocId, String bstrVersion, Object& pvarAttachmentNames, Object& pvarAttachmentContents, Object& pvarProperties, Boolean bCheckOut, Boolean bCheckin, Boolean bMigration, Boolean bPublish)     at Microsoft.SharePoint.Librar

Authentication/Firewall problem and Visual studio 2010

  

i have windows server 2008 running on my pc. i have been able to setup client/server network with a domain. i login on th e client pc and tried to create a website project with VS2010. but each time i choose iis7 of the server i get the following error : the web server does not appear to have any authentication methods enabled. It asked for user authentication, but did not send a WWW-Authenticate header. although i have enable form authentication on the web server and i can access from the client pc the default page of IIS7.Does anyone have any explanation on that? thanks


Cannot connect Visual Studio 2008 to Sql Server 2005

  

I have Windows 7 and installed Visual Studio 2008 Pro and also installed SQL server developer addiotion that comes with VS. After creating a test database in SQL maangement studio and adding the standard asp.net membership provider tables with the aspnet_regsql tool, I created a web project and added a connection string to the web.config file to connect to the database.

No matter what, I cannot connect to the database.

I can create a connection through the server explorer in visual studio and when I drag a sqldatasource onto my page and configure it I can connect to the database etc. But no web.config connection.

This worked on my XP pro machine but not Windows 7.

Has anybody had this problem and what am I doing wrong.

thanks


Visual Studio 2010 installation without SQLExpress

  

Hello, 

I installed Visual Studio 2010 Professional using custom settings and decided not to install SQLEXPRESS. The reason being is that I already have an instance of SQL Server 2005 Developer. Now, when I try to use ASP.NET Configuration (Security Tab),  I receive an "unable to connect to Sql Server database" error. Can anyone help me resolve this issue?  




Errors while Build the "Forms Authentication Sample" using Visual Studio 2010

  
Hi All,

      While Build the solution Custom Security Project getting Errors

I am using SharePonit 2010 with Sql Server 2008 R2.

1. I configured Reporting Services and able get the reports using with Windows authentication.

2. Now my web application is Claims Based. Using with Claims Based Auth i need to get the reports. Since 5months i had this task in pending.

I need to configure the Reporting Services using with Forms Auth.

For this  recently i read this link http://technet.microsoft.com/en-us/library/aa902691%28SQL.80%29.aspx#ufairs_topic1

After downloading Code file from above link opened .sln file and converted.

Here added reference 'Microsoft.ReportingServices.Interfaces.dll'  from   C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer\bin this path.

While i am going for build getting these two errors

 1. 'Microsoft.Samples.ReportingServices.CustomSecurity.Authorization' does not implement interface member 'Microsoft.ReportingServices.Interfaces.IAuthorizationExtension.CheckAccess(string, System.IntPtr, byte[], Microsoft.ReportingServices.Interfaces.ModelItemOperation)' C:\Program Files (x86)\Microsoft SQL Server\MSSQL\Reporting Services\Samples\Extensions\FormsAuthe

After Install of Visual Studio 2010 SQLServer 2008 cannot Connect

  

SQL Server 2008 was working fine. I have Visual C# 2008 Express Installed.

I just installed Visual Studio 2010 Professional and now I cannot connect to SQL Server 2008.

One of the forums said to install SP1, VS studio 2010 comes with SP1.


Can't connect to SQL Express 2008 from Visual Studio, but can connect from SQL Server Management St

  

 

I've been struggling with the following issue for 3 days:  I can access and use my SQL Express 2008R2 database flawlessly from SQL Server Management Studio.  But I can only intermittently access it from Visual Studio (ultimate edition with TF Server).  Sometimes it works, sometimes it doesn't.  I mostly see the error when I try to "Update Model from Database" within my Entity framework model, or when I try to access the database from within Server Explorer.

 

Here is the error I see when I try to update my Entities form the Database: An error occurred while connecting to the database.  The database might be unavailable.  An exception of type 'System.Data.SqlClient.SqlException' occurred.  The error message is: 'Cannot open user default database. Login failed.  Login failed for user 'Tim-PC\Tim'.'

 

I think the connection string is fine as I am able to connect

How to connect button in visual studio with other program!

  

Hello!
I have a litlle problem with my program!
I want to type a code on a button.
When I click on first floor( "Prvi Kat" ) I want it to application navigate to my other program and run it.
It is possible? If yes, how?
Need a litlle tut here.
Thank you!
Here is a screenshot of my program soo you can see what I meant.

 

http://imageshack.us/photo/my-images/691/unledtb.jpg/


Categories: 
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