I had sql express and microsoft express accounting working fine on xp. When I updated to vista and reinstalled sqlexpress with sp1 and management express sp1, I can not get the server to register. Any command I click gives error message "this type of initializer <module> threw and exception". Also when I tried to install accounting from office 2007 cd, will not install giving same message. Ihave uninstalled and reinstalled sql express w sp1 several times with no success. I can find no reference to this error message anywhere. Anybody got an idea where I can do to get this to work properly? Thanks in advance.
First of all, I am a self taught programmer, and a Sql Neophyte, and know just enough to get confused (or in trouble). I have a TabletPC app that uses SqlExpress, installing as 'Click Once'. Works great on XP, but my app comes to a screeching halt on Vista, because of the permissions/contact network administrator issue. I read Mike's post (dated a year ago, Oct 06) about using SSMSE to create a new Login with sysadmin rights for the current user. Long story short, completed it successfully, but it didn't work.
I have been browsing posts here on the subject, but I am confused. Does my Vista user need to install SP2? Will that fix the problem? I am sorry, but some of the posts on this subject are over my head.
Could I prevail on one of the moderators to point me in the right direction, or to explain in v-e-r-y b-a-s-i-c terms what I need to do to help my Vista users access my SqlExpress DB?
I just installed a brand new Business Vista and moved my old databases from WinXP to this partition. Everything seemed to be OK for a couple of days but now I am getting some errors I cannot resolve. There is no online help for this topic.
Just a bit of background. I have to establish connections between my Sql Server databases and an MS Visual Management Studio 2005. I think the trouble began after I started doing connections this morning.
Before that did established connections between the two successfully but for various reasons I had to delete them, download the folder with databases anew and start from scratch. I do not quite remember what the trouble was but it was serious. I could not really use the connections in the VS.
When I began setting up connections today the Vista complained that I did not have permissions to access those files. OK, I went to the database folder and individually gave permissions to two groups I previously set up: Debugger & Microsoft Visual Studio. They both have the same users: me and administrator who is myself.
After that act I tried to open connections again (in VS). I got an error that user instances were disabled. It said: use sp_configure to enable user instances.
I went to Sql Server and tried to do just that. Before I could execute queries. Now I am getting errors even when I try to open a new query.
TITLE: Microsoft SQL Server Management Studio Express ------------------------------ Cannot show requested dialog. ------------------------------ ADDITIONAL INFORMATION: Cannot show requested dialog. (Microsoft.SqlServer.Express.SqlMgmt) ------------------------------ Failed to retrieve data for this request. (Microsoft.SqlServer.Express.SqlManagerUI) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476 ------------------------------ Failed to connect to server DDMNVT61. (Microsoft.SqlServer.Express.ConnectionInfo) ------------------------------ A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=233&LinkId=20476
OK, this thing appeared to have been resolved just a minute ago but I still decided to keep it here perhaps someone will comment on it because the way I resolved it was a total lack of understanding how I did it. Just clicked here and there and that was it.
Now need to resolve the user instances issue. I used sp_configure stored procedure in a query and got the result that the maximum number of user instances is 1. I do not know how I can change this parameter. I tried to use sp_configure with parameters with no good result.
If anyone know how to do it, please help.
Thanks.
P.S. I am sorry, that error has not been resolved. I keep getting it.
When I installed VS2005, a copy of SQLEXPRESS was also installed. It appears that it was installed using WIndows Authentication. It doesn't show up in Programs and Features or the VS2005 Setup so I can't remove it and install it using a userid and password. Is there a default userID and password that it was installed with?
I have an application that for the most part uses a local SQLExpress database, but might link to another server. The application has worked OK, and is is written in VB using ADO, and some DMO. I guess I lucked out prior to Vista, because I used the Builtin/User login and could create, attach, or alter existing databases. With Vista and UAC, I don't have the required privileges.
What can I do during an install (presumably as an administrator) to grant the required privilege to the builtin/user? Or shouldn't I be using the builtin/user?
Can I give the builtin/user "Create Database on Master" during an install, and then they would be able to create databases, when the app runs under a user?
Sorry for the ignorance - I'm pretty new to SQL and ADO.
I am trying to connect to a SQLExpress installed on Vista through the network. I did enable all protocolls and in the Surface Area Configuration I activated Remote Connections ("using both TCP/IP and named pipes"). But still I get the following error:
"An error has occured while establishing a connection to the serveR. When connection to SQL Server 2005, this failure may be caused by the fact that uder the default settings SQL Server does not allow remote connections. (provider: SQL Network Interface, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server)"
This what happened in Vista. I just set up my SqlServer Express (SSMS), attached my databases: all of them except one.
The reason why it happened is that when I copied my folder with DBs from XP to Vista I found out that one mdf file was missing.There was the log file for that DB intact. It is a somewhat secondar database (at leas temporary until I will have resolved some tricky issues in C# app, then it will get full load). When I bagan chenging my conn strings in C# to accomodate new Vista's tastes I realized that that DB was not attached to VS 2005 either. I began to investigate.
I went to XP and checked thoroughly. First I thought this DB (mdf file for this DB) was stored in another partition. It does not seem to be the case. The entire disk was searched: nothing found.
The weird thing is: I can see this DB in SSMS in XP with ALL tables intact. I opened the design and also opened the tables. The values are all there. This is my first question: how can it be explained? Could it be that all the tables are in the log file for this DB?
So at this point I have no way to copy the DB from XP to Vista the way I did before with other DBs.
The next problem is this:
I went to Vista and tried to restore this DB from a backup. The backup may not be too fresh but I do not care. All I need is the structures and stored procedures. Vista gives me hard time.
This is my code:
RESTORE DATABASE [intraDay] FROM DISK = 'J:SqlServerBackUpsIntraDayintraDayFullRM.BAK' WITH RECOVERY,
TO 'C:intraDay.mdf'; -- this is just to try the RESTORE in principle. I will restore the DB to a different folder.
GO
I get an error that
Msg 156, Level 15, State 1, Line 2
Incorrect syntax near the keyword 'TO'.
I understand that the MOVE clause may be missing. I tried that but got in trouble with it as well.
Clean vista install, Clean full office 2007plus install Clean visual studio 2008pro install Many failed sql 2005dev installed, did SKUUPGRADE-1 Now have office2007 Smallbiz, VS2008pro, SqlExpress and sql 2005dev installed. Note outlook 2007 error on first run after sql2005dev. Seams to have broken and created a new sql connection, don€™t think its the original. but that€™s not the current issue ! web admin page error, could not connect to db I did regsql.exe from the net dir and the web admin work and the db is created for roles and such in vs 2008 via web admin page and mssql. Managed to create db in apps data folder and modify connection in server explorer. Added table to aspx page from apps folder and it runs via f5, but errors under localhost. €œCannot open user default database. Login failed.€? €œLogin failed for user 'NT AUTHORITYNETWORK SERVICE'€? Have seen some reference to iis permissions, but not sure what to change? Is it a file level permission, a virtual permission Works in vs2008 using f5 run! http://localhost:50115/vs2008/ Can work with apps folder db file in vs 2008 server explorer Had to modify db connection back to sqlexpress in server explorer Can work with db in sql management studio, have three local instances; Pc Pcsqlexpress Pcsmallbiz Can display db data in aspx page via f5 , but not localhost unless vs2008 is not running!!! Have not been able to make vs2008, Sql2005dev, sqlexpress all work together using iis in vista via localhost and vs2008 f5 at same time?? Can€™t do anything with db in solutions explorer, but can work in server explorer if I modify connection back to sqlexpress Can€™t display data aspx page via localhost http://localhost/vs2008/ Cannot open user default database. Login failed. Login failed for user 'NT AUTHORITYNETWORK SERVICE' Localhost works in iis via virtual directory if I remove db grid in page or vs is not running Could someone test and tell how to use all of these together? What is going to happen if I get it to work local and then try to upload to shared host? <connectionStrings> <remove name="LocalSqlServer" /> <add name="LocalSqlServer" connectionString="Server=wabpc;Database=VS2008test;Integrated Security=true" providerName="System.Data.SqlClient" /> <add connectionString="Server=SQLEXPRESS;Database=Database.mdf;Integrated Security=true" name="sqlexpress" />
</connectionStrings> If I close vs2008 and the management studio, localhost works and displays the db info!! Open vs2008, modify connection back to sqlexpress and the aspx page breaks via localhost Close vs2008 and local host works Open vs2008 and get a error 25 in server explorer connection string invalid, but f5 works after the offline clears. I change db connection back to sqlexpress to work with db in server explorer! That breaks localhost, but f5 works
The SQL ERRORLOG shows: Error is 3414, Severity 21, State 2 and says: "An error occurred during recovery, preventing the database 'model' (database ID 3) from restarting." Just prior to this, I get a warning: "did not see LP_CKPT_END".
Any thoughts why this might be and how I can fix this?
I have created an installation application which will install the application with SQL Express and .NET Framework 2.0.
If i install this application in a Fresh system(i.e which is not having SQL Express), it is installing the application with new database instance successfully.
But if i try to install the same in a system which is already having SQL Express, throwing "Object reference exception" because it is not able to create the new database instance.
Because of numerous problems trying to get sqlexpress working, I uninstalled it with the intention of reinstalling (via Add or Remove Programs). However, now when I try to reinstall it, I get a message that the I am not making a changes so it won't let me install it.
I do have sql server 2005 developer's edition installed; is that the reason? and does that mean I cannot have both installed on the same machine?
Hi All,I've been struggling with this for hours...Could someone please advise me on how to convert my current File based SQL Server Express website to a Server based SQL Express one.Particularly interested in what I need to do in the SQL Express management tool, changes I need to make the projecvt itself and changes needed to get IIS to understand things have been changed.Thanks,Martin.
Hi I'm pretty new to all of this. I downloded a starter kit and am a bit confised as to SQLExpress. I have SQL Server already installed and just wondering what the option are. I am currently using Visual Web Developer Express Edition and in the config file data source is SQLExpress and can't go any further. I don't want to mess with my current setup so just want to get some sugestions first. Anyway hope this makes sense. Thanks GP
I have just created a website with membership just using the standard SqlExpress auto generated file Everything works fine until I upload it to webspace :( I get the following Error An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) I don't have SQL Server 2005 :(
if my SQl server/COnnection is "SQL EXPRESS"..Im using an Import name "Import System.SqlClient" on every web form that i have... as well as other SQl command name like "SQLConnection,SQLCommand etc..."is this the correct that im using all sqlcommand in my webform??? well sorry for this im just new..and one more thing..can i include Ado.net on it if my connection is "SQLEXPRESS" just i said? Thanks for the answer....
I am new to this forum . I am running through few problems for sqlserver account settings .
I) My registery key entry for MSSQLserver just has a client folder . 2) My sql server configuration manager just has sqlserver 2005 services , native client configuration and 2005 network configuration.
I can't see any server name or databases under it.
3)I normally work on EMS lite so I can see my ./SQLEXPRESS as server and databases under it and i can create logins etc ..I assigned db_owner role to one of my recent created database. but when I try to connect it says :
The user is not associated with sqlserver connection.
5) i have sqlserver express service running, vss and sql server browser running.
I googled and searched for the solution and it says the authentication mode should be turned to mix mode form win authentication.
But from where. Have i missed some installation .I am able to connect to my other database from EMS.
I am trying to write an application for a MSSQL database, using SQL Express,and Visual Studio (Express edition)I tried to connect to an existing database (named testing) but to no avail.Visual Studio claims the database does not exist.Any ideas?TIA--Q: What is the difference between a mathematician and a philosopher?A: The mathematician only needs paper, pencil, and a trash bin for hiswork - the philosopher can do without the trash bin...
Installation of SP2 in step "Feature Selection" shows SQLEXPRESS unchecked and can''t be edited/checked. I tried it many times on different servers with different OSes, etc
Does it mean that SP2 for Expres Edition should be downloaded and applieв separately?
Hello,I am just getting reaquainted with programming and all. I work in GIS mapping and am having diffilculty using a ASP.net internet Map site and adding records to a needed database.I would like to be able to add records to a linked SQLExpress table when the user clicks on a map location. I adapted the following code snippet from an example that does what I would like only using an .mdb file.CODE: // create connection to database var connection; connection = Server.CreateObject("ADODB.Connection"); connection.Open("Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=OutdoorsExp;Data Source=NOLOGOSQLEXPRESS;"); status = "Can't access 'FishSQL' table."; // create recordset var recordset; recordset = Server.CreateObject("ADODB.Recordset"); recordset.CursorType = 1 recordset.LockType = 3; recordset.Open("dbo.FishTable", connection); status = "Can't append new record."; // append record for clicked location recordset.AddNew(); recordset.Fields("LongitudeI").Value = xco; recordset.Fields("LatitudeI").Value = yco; recordset.Update(); recordset.Close(); // release the .mdb file connection.Close();However, this does not add anything to the SQLEx table. What am I missing? I am thinking that it might have something to with the primary key.I had a table with way more columns then just lat/longs (as above) but only coded it to add data to the latitude and longitude fields. Nothing got added of course. Would have to add data to every field that doesnt allow nulls.How do I generate a random, unique ID for a primary key on the fly and for example add it to the appropriate column.Thanks you in adavnce for any insights.
To be as brief as possible:I had Visual Studio 2005 installed with SQLExpress 2005. worked reallll good :) I needed to convert an excell spreadsheet to SQL, so I migrated it to Access. Then the upsizing wizard would not/could not create an sql table with the data. Just would not take the data when the table was created. Argh.FINALLY figured out that the SQLexpress 2005 doesn't come with import/export.So I uninstalled the sqlexpress and installed SQL 2000 - Developer. Veeola, able to convert and created the table I needed.Now Visual Studio 2005 won't let me touch the sql file, says it requires sql server express 2005.My ISP does not support SQL 2005 yet. Is there anyway to get Visual Studio 2005 to work with SQL 2000 (only?)If I install SQLExpress over again, will it create problems when I go to publish my website, and more importantly right now, will anything bad happen when I reinstall sql express, or do I need to uninstall SQL 2000 first? Thanks...
hi:I set up a DSN via Adim tools, then I specify the connection string as "DSN=UserAppSample;Trusted_Connection=True".When I run my aspx page, it says: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database "UserAppSample" requested by the login. The login failed. It asks for login, but I use windows authentication. So what is wrong with this? :(
** For those 20 users (or fewer) who've read http://forums.asp.net/thread/1692306.aspx, I'm sorry that I ask the same question.Like I said above, what is the limitation of SQLEXPRESS, in terms of performance and scability?I'm creating a new webboard application that will replace the old one. I intend it to handle 200 concurrent users + 70000 records (9 years of data)The current system use Microsoft Access, which is reaching it's limit in performance and size. I took a look in the SQL Server product information page : http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx.It didn't tell me what I want, like how many connections it can handle, for example.If there are limitations that might cause my application to not reach the required specification (above), I may need to switch to MySQL. I've no intention buying a licensed SQL Server 2005.Thanks in advance.PS: Why there're so few users viewing my posts? Anyone know a more active forum that may help me?
i'm using sqlexpress edition for my application and i'm wondering whether i will be able to execute the below sql statement use masteralter database <dbname> SET ENABLE_BROKER when i execute the above two lines its executing from last 30+ minutes... i'm wondering will that support in sqlexpress edition ? also, in order to use sqldependency do i have to enable broker service? thanks.
Ok it seems to me that if you use the ms recommended code to connect your apps using the app_data folder etc, that the dbs never show up in the SQLExpress manager.So I can't back them up like I can databases I connect to SQLExpress the 'old fashioned way'. Only 2 out of 6 dbs are visible in SQLExpress manager.What is the proper way to do this?Thanks,Jamey
1. Is there a white paper on how to upgrade an SQLExpress DataFile to a SQLServer attached database? 2. More importantly: Is there a way to upgrade a Beta 2 SqlExpress database to a RTM version? This lack of compatibility between beta 2 and RTM is killing me. Are their any resources for this transformation? Would be great!
As of right now I have two networked machines. I have a sql database on one that I have no problem connecting to, but I cannot connect to the database from the second machine.
From the second machine, I've come up with this connection string after all my research...
"server=[MACHINE_NAME]SQLExpress;databse=[NAME];User ID = sa;Password=[PASS]"
I keep getting a cannot connect to database error.
I know this isn't exactly SQL help, but I alwasy get great help here and thought someone might know why I'm having problems. I'm trying to map to a drive where I have a SQLExpress database on another computer within a workgroup. This is the cmd line I'm using...
NET USE * \XPPRO1SQLExpress /USER:Admin /SAVECRED /PERSISTENT: YES
I'm thinking the problem is with the * (which names the new drive with the next available letter), or that I have to use a password. Everything I've found says nothing about specifying a password though.
The error message I get says "A command was used with conflicting switches."
I just reinstalled SQLExpress and all the dbs that I created are no more linked. The files still exist in the folder where the current version stores dbs (...Microsoft SQL ServerMSSQL.1MSSQLData) but they are not "linked" (don't know the right term).
Is there anybody who could help me how to "relink" these dbs to the actual .SQLExpress instance?
Hi friends I insalled Visual Studio 2005 standard edi on XP machine. as you all know it also installs sqlexpress. i want to uninstall this sqlexpress as i also have sql server 2005 standard edition on my machine.
but i dont see any option to uninstall in add/remove programs or in start menu for sqlexpress. any ideas on this ? Thanks for your help.
I made a big mistake and deleted this program and now I cannot reinstall it. I get error messages stating that an instance is already on my machine and I need a unique name to restart install. I also get messages that say to install from the command line but I cannot get there the only access I have is error reporting. Is there any way I can make a FREASH install of this program????
I have finish building my ASP.NET site using VS 2005 and it compile just fine. Than I try hosting it to the web via IIS v5.1 and I am getting permission error from SQL express.
I have posted a detail question in experts-exchange.com and since you need a user account to even view the thread, I have taken the liberty to save the thread as .html file and host it to my ISP site. You can see the detail problem I am having here: http://users.accesscomm.ca/mm/EEdetail.html
I am going to list out some stuff I have done:
1. I have two database that need access, the ASPNETDB.mdf for user login and another database (PhotoDataBase.mdf) to store information relating to the photo I uploaded to my ASP.NET site.
2. I have already follow this How to site: http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx and setup: - TCP/IP enable, as shown here: - I have started SQL Browser service - The firewall part I am not so sure about. I am currently using Zonealarm....
3. I have installed SQL Server Management Studio Express(SSMSE) and attach the two database to it.
4. I have set SSMSE server properties to accept both SQL and window authentication.
5. I have made sure that both database "read only" setting to false
6. I have setup SQL login with User ID = SQLLOGIN
Here is the original connection in web.config: <add name="ConnectionString" connectionString="Data Source=.SQLEXPRESS;AttachDbFilename=|Da taDirectory|PhotoDataBase.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient" />
and here is the new connection I just type in web.config that replace the original one: <add name="ConnectionString" connectionString="Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|PhotoDataBase.mdf; Server=MINGDESKTOP; Integrated Security=False; uid=SQLLOGIN; Password=XXXXXX;" providerName="System.Data.SqlClient" />
and the error i get are the follow:
Server Error in '/' Application. An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) 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: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
7. I did haven't done much to ASPNETDB.mdf yet and the error i get right now are the following:
________________________________________ __________________ Server Error in '/' Application. Cannot open user default database. Login failed. Login failed for user 'MINGDESKTOPASPNET'. 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 user default database. Login failed. Login failed for user 'MINGDESKTOPASPNET'. _______________________________________________
Please help! I am really running out of ideas.... and I need to have this setup in a few days....
Hi, I'm using Microsoft SQL Sever Management Studio Express. But all of a sudden, if I clicked connect button, the messageBox pops up and it doesn't let me connect. It says "TITLE: Connect to Server ------------------------------
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476
------------------------------ BUTTONS:
OK ------------------------------ I didn't have such a problem before. If someone could help to solve to this problem, I appreciate it. Thanks.
