sql server and sql server express conflict

hey all please help me ....i have been working on this issue for 2 days i created a web application with a automatically generated security database and added tables to it and it was working fine...i had to a linked server the linked server cannot be added from sql server express so i installed the full version...it was working fine until suddenly i got this 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" so i searched and searched then i found out that i cannot have the two versions of sql server so i de installed the express version and had many bugs to fix in order to open the database from the sqlserver management studio... and after it worked i started vs2008 and tried to open the db and it turns out i cannot do that since i need the express version so im stuck pleeeeassse help me
0
bobz_0585
3/1/2009 11:13:04 AM
asp.net.sql-datasource 29906 articles. 0 followers. Follow

2 Replies
1003 Views

Similar Articles

[PageSpeed] 46

"i started vs2008 and tried to open the db"

what does this mean?  If you try and run your web site if fails or if you try and view the database/tables etc. from within Visual Studio.  Sounds like you have some connection string issues.  When you switched to the full version of SQL Server did you change your connection strings?  If not you have to make new ones since the express/full version can be different.

 See http://connectionstrings.com/ for samples of connection strings for both express and full SQL Server.


- William

Please mark the most helpful reply/replies as "Answer".

Give some of my PWSK modules a try.
0
whighfield
3/1/2009 4:20:50 PM
ok thanks man i tried many connection string but it finally worked thanks
0
bobz_0585
3/2/2009 10:20:31 AM
Reply:

Similar Artilces:

SQL Server 2005 Installation problems with SQL Server Express & SQL Server 2000
Hi Guys, I have had SQL Server Express and Sql Server Management Studio Express installed on my machine for some time and recently tried to install a trial of SQL Server 2005 as well.  (Yes, I'm migrating from Visual Studio Express to Visual Studio Professional, just as in tended!) Everything went fine except that nothing seemed to be installed.  I searched in all the obvious places - both on the Start/Programs menu and on the hard-drive: nothing. A check under Add/Remove Programs showed that Sql Server 2005 Express was installed, but called SQL Server 2005. So after a number o...

Converting MDF files (SQL Server Express) to SQL Server 2005 WITHOUT having to buy SQL Server 2005 (I have Express). Personal WebSite Starter Kit
Hi (and HELP!),   I downloaded the Personal WebSite Starter Kit and got it working no problem on my local machine.  But I've had nothing but frustration trying to get it up and running on a webhosting site.  I picked hostmysite.com which uses SQL Server 2005.  I was under the impression that it wouldn't be that big a deal to convert the .MDF files that Sql Server Express uses to a SQL Server 2005 database.  I tried using SQL Server Management Studio Express.  I was able to "see" my remote database on hostmysite.com, but I was not able to import the .mdf files ...

Converting MDF files (SQL Server Express) to SQL Server 2005 WITHOUT having to buy SQL Server 2005 (I have Express). Personal WebSite Starter Kit
Hi,Basically i built a webpage with Login and it's working well from my local machine.Right now, i'm using Database Publishing Wizard. the problem is how do i convert.MDF files to .SQL 2005 to get my database publish in the internet? thanks  Place your .MDF file in the App_Data directory, change the connection string accordingly and then publish your web site. ----------------------------------------------------------Please click Mark As Answer if this helped in solving your problem.  Please click "Mark As Answer" if this hepled in solving your problem. ...

Converting MDF files (SQL Server Express) to SQL Server 2005 WITHOUT having to buy SQL Server 2005 (I have Express). Personal WebSite Starter Kit
Hi (and HELP!),   I downloaded the Personal WebSite Starter Kit and got it working no problem on my local machine.  But I've had nothing but frustration trying to get it up and running on a webhosting site.  I picked hostmysite.com which uses SQL Server 2005.  I was under the impression that it wouldn't be that big a deal to convert the .MDF files that Sql Server Express uses to a SQL Server 2005 database.  I tried using SQL Server Management Studio Express.  I was able to "see" my remote database on hostmysite.com, but I was not able to import the .mdf file...

sql server and sql server express
ok i am puzzled right now....i have a web application connecting to a sql server database....i uninstalled sql server express and installed sql server 2005 full version...i changed the connection string in my application to be Data Source=SKYBANDR62;Initial Catalog=aspnetdb;Integrated Security=True and through the explorer bar i can access my database freely but when i run my application i get this error Server Error in '/' Application. -------------------------------------------------------------------------------- An error has occurred while establishing a...

Confliction between SQL Server 2005 and SQL Server 2005 Express Edition
Hi,   My objective is using a single DB file (mdf file)  + SQL Server Express 2005 to run my program   I got two softwares here, Visual Studio 2005 and SQL Server 2005. Firstly, I installed Visual Studio 2005, normally the SQL Server 2005 Express Edition will be installed with this software. After finishing the installation. I opened a new project and try to open a DB file (.mdf) from Visual Studio 2005, it works. The problem is that I can't restore the mdf file from an old database file since it lose a lot of functions that appear in SQL Server 2000 / SQL Server 2005. ...

Deploy Sql Server Express DB to Sql Server Express
I have developed by webite with Visual Studio 2005 and sql server express. I'm trying to deploy my website to a VPS with sql server express running on it I ftp'd the App_Data folder to the remote via the 'copy web site' Everything seemed okay until I started trying to run more complex database operations using stored procedures and transactions. It appears that the schema is messed up because when defining the parameters for a stored procedure, upon ExecuteNonQuery I get the error that I've assigned too many parameters which I have not (since it runs fine on...

SQL Server Express file to Sql Server
I would like to copy the schema and data of a sql server express database file to a SQL Server Database. How can this be done and what steps would I need to take?   Thanks for any helpTinyPond TinyPond:I would like to copy the schema and data of a sql server express database file to a SQL Server Database. How can this be done and what steps would I need to take? If you have Express Management Studio, you back backup your database, and them import it to SQL Server (or attach and reattach).Justs open SQL Server Express Management Studio, connect to your Express instanc...

Mixing SQL Server and SQL Server Express
VWD 2008 Express.  Visual Basic. I have some questions: 1.  If I create a web site that uses a local database (stored in a directory in my web site's root directory) handled by SQL Server 2008 Express, what happens when I move the site from VWD to my server?  My server has SQL Server 2005 Standard running on it.  Will my site run even if SQL Server 2008 Express is not installed on the server?  Do I need to install SQL Server 2008 Express on my server? 2.  Can my Windows 2003 Server run both SQL Server 2005 Standard and SQL Server 2008 Expre...

SQL SERVER EXPRESS versus SQL SERVER
Would anyone really use ASPNET2 Membership Services with its built in Sql Server Express database for a major, heavy traffic website? How well would sql server express handle 1 million members? Can anyone point me to an article comparing performance of full blow Sql Server with (watered down?) Sql Server Express? Seems to me you already know the answer to this question in the way you ask the question.  SQL Server express is just for normal web applications for learning/teaching and small time deployment.  Obviously by logic heavy traffic ( esp in the 1 million range even in t...

SQL Server Express and SQL Server 2005
can any one tell me what the main differences are in the two editions? also can you use and express 2005 edition database on sql 2005? if not how would you do that? Tuppers Look here for a detailed comparison between the two.Yes, you can use Express databases on SQL Server 2005. Just attach it to an instance of SQL Server 2005.Is this enough information?DonDon Kiely, MCP, MCSDIn the Last Frontier, Interior AlaskaPlease post questions and replies to the forum! And remember to MARK AS ANSWER when someone definitively answers a question or resolves a problem! cheers i was told by my host t...

SQL Server Express
I'm developing applications with VWD Beta1 and SQLServer Express, and when its possible I'll want to publish it on the INet. I'll probably publish it in a server with SQLServer (without Express), and I want to know if I will have to change something in my code for this change. Thanks!!subgurim.net: blog de ASP.NET 2.0 con C# en castellanoes-asp.net: el portal de ASP.NET en castellano If you don't use any specific SQl 2005 Features, you should probably not need to change your code (Maybe only the connection string so it will target the other Sql Server)./Fredrik Normén - fredrikn @ tw...

This version of Microsoft Sql Server Management Studio can only be used to connect to Sql Server 2000 and Sql Server 2005 servers
When I connect SQL Server 2005 to a remote database i get the error: "This version of Microsoft Sql Server Management Studio can only be used to connect to Sql Server 2000 and Sql Server 2005 servers". Can I confirm it is because: the remote db is of SQL Server 2008? There is a soln mentioned in http://forums.asp.net/t/1324047.aspx Did anybody try this (installing 2008 express: http://www.microsoft.com/express/sql/download/)? I am just checking again, whether it will disturb my existing SQL Server installation, in any means...? Though it is mentioned that it will g...

How to connect to my sql server express,also Pubs and northwind for sql server express
1, I have installed VWD express,sql server 2005 express.I also install management studio and adventureswork db.In the management studio I can able to connect and view adventurework db.But I can't manage to make a connection string to my db server when connecting to management studio server name is "KAMRANSHAHID\SQLEXPRESS".I wants a connection string with respect to this server.2,Is there new database for pubs and northwind for sql server 2005.Or they are of old sql server 2000.I have installed sample databases but can't find script for pubs and northwind nor it install automatically.I wan't...

Web resources about - sql server and sql server express conflict - asp.net.sql-datasource

Fatah–Hamas conflict - Wikipedia, the free encyclopedia
The Fatah–Hamas conflict ( Arabic : النزاع بين فتح وحماس ‎ an-Nizāʿ bayna Fataḥ wa-Ḥamās ), also referred to as the Palestinian Civil War (Arabic: ...

Melbourne's Metropolitan Fire Brigade gripped by 'culture of conflict'
A harmful "culture of conflict" is plaguing the Metropolitan Fire Brigade, according to an outgoing board member who has resigned partly ...

JPMorgan admits it didn't tell customers about conflicts
JPMorgan will pay more than $400 million to settle allegations it didn't make numerous conflicts of interest known to clients.

JPMorgan Admits It Didn't Tell Clients About Conflicts
... to settle U.S. allegations that it didn’t properly inform clients about what the Securities and Exchange Commission called numerous conflicts ...

Trump: Putin’s Praise of Me ‘Terrific,’ Mutual Dislike With Obama Is Cause for Conflict, Omnibus ‘Very ...
Trump: Putin's Praise of Me 'Terrific,' Mutual Dislike With Obama Is Cause for Conflict, Omnibus 'Very Disappointing'

Taylor Swift has another rap conflict
Data from iHeartMedia showed the top songs across the country during the year. But it turns out the data are far from correct.

To Avoid Decision Spin, Managers Need To Embrace Conflict
Companies can’t afford to let decisions spin around with no resolution. Shortening that cycle requires managers to embrace conflict rather than ...

OBAMACARE CONFLICT Rubio plan to kill insurer bailout rule stirs debate
OBAMACARE CONFLICT Rubio plan to kill insurer bailout rule stirs debate

UN Approves Resolution on Impact of Conflict on Youths
UN approves resolution focusing on impact of conflict on youths and rise of radicalization

Chief Justice Roberts Made 'Human Error' In Overlooking Conflict Of Interest
... where he had a significant financial stake. Earlier this year, a Supreme Court justice took action in a case where he had an unintended conflict ...

Resources last updated: 12/22/2015 1:50:53 AM