Whenever I open a .sql file in QA, the dialog box always displays the files in the 'list' format (you need to scroll side-to-side to see the files). However, I prefer the 'details' format, where I can see the file size and the date created (and sort by them).
Does anyone know how to change the default so I can open files the way I want to open them?
I get the below error only when my IDE open. It connects well when it is found closed.
[SqlException (0x80131904): Cannot open user default database. Login failed.Login failed for user 'JPASPNET'.]
I could solve this by giving the logged in windows user to impersonate under IIS window > WEBSITE > ASP.NET tab > EDIT CONFIG > APPLICATION tab
But I wish someone could give me the proper solution.
I almost tried all from giving ASPNET user as a administrator to configuring the same in Express management tool.
Environment: XP pro, VWD and SQL Express
Hi,
I am using SSRS Microsoft SQL Server Reporting Services Designers
Version 9.00.1399.00. I want to open linked report in new window.
I tried whats mentioned in http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=240172&SiteID=1 but i get an error on Window.Open method.
How do I solve the problem?
Thanks
We have a SQL Server 2000 in a Windows 2003 Server, and we were working very well with the VB 6.0, but after an update in the Windows 2003, the Open method in ADO results in an error -2147467259 sometimes, but if we try the same code in a computer with another domain there are not any problem, some advice?
View 1 Replies View RelatedHello group!I use MS Visual C++ 6.0, ADO, MS SQL Server 2000.When I attempt to open my database I meet with a following problem:when I try to get a bookmark of the current record in a Recordsetobject a following run-time error occurs: Unhandled exception intestdb.exe(KERNEL32.DLL):0xE06D7363: Microsoft C++ Exception.I created my database by 3 SQL commands:create database testdbcreate table testtable(i int)insert into testtable values(0)The error occurs in the following code snippet:#import "D:Program FilesCommon FilesSystemADOmsado15.dll" no_namespace rename("EOF", "EndOfFile")int main(){CoInitialize(NULL);bstr_t strCnn("Provider=sqloledb;Data Source=;""Initial Catalog=testdb;Trusted_Connection=YES;");const char* tablename = "testtable";_RecordsetPtr recs;recs.CreateInstance(__uuidof(Recordset) );recs -> Open(tablename, strCnn, adOpenStatic,adLockOptimistic,adCmdTable);_variant_t bm = recs -> Bookmark; // the error occurs hererecs -> Close();CoUninitialize();}During the debugging this code I met that the error depended on a typeof locking. When I set adLockBatchOptimistic or adLockOptimisticor adLockPessimistic the error occurs but when I set adLockReadOnly oradLockUnspecified it doesn't occur. By the way this error doesn'toccur whenI open Pubs database with any type of locking. What is a cause of thiserror?Thank you.
View 1 Replies View Related
Ladies and Gents,
I have a question with regards to the default rendering extensions for reports. I am using RS 2005 with SP1.
I am accessing a report as follows:
http://<ReportServerName>/Reportserver?/<Folder>/<Report Name>
Sample: http://TestServer/Reportserver?/Special Reports/Dealer Report
This displays the parameter bar and the view report button. When pressing the view report button, the report is automatically rendered into HTML 4.0. Is there a way to use the existing parameter bar and automatically render the report to a different extension (such as PDF) when the parameters are entered and the View Report Button is pressed.
Thank You for any advice you can give,
Raph
There was a 2008 SSRS service running on server "abc".
I have a .Net UI that uses the wsdl at [URL] ....
They deployed SSRS 2012 service on a new server "xyz".
DNS points abc to xyz. Nslookup looks right shows both xyz and abc alias to the same IP.
when I try to go to [URL] .... it redirects to xyz as expected for the host name but the HTTP GET /ReportServer is appended with GET /Reports/ReportServer which doesn't exist and I get an 404 error.
I have no admin rights to see anything and I have no idea if it was an inplace upgrade or a new server. I assume it's new since the actual server name changed in nslookup. Why would it append the default virtual directory when it makes the hop to server "xyz"?
Hi Team
I am working on a .net project, sql server 2000 based one. Now when iam connection to database server (remote) then me getting an error that the user cannot open the default database. I have made the database > all tasks > take offline. But after that I cant open the sql server thru the enterprise manager and query analyzer. How can I do the database online?
Thanks
Rajesh
When i try to open the Adventureworks database with SQL Server 2005 Express, it throws the following error:
Cannot open user default database. Login failed.Login failed for user 'SK-RIY37EQBYCYZsk'.
Dim connString As String = ConfigurationManager.ConnectionStrings("AdWorkConnectionString").ConnectionString
<add name="AdworkConnectionString" connectionString="Data Source=.SQLEXPRESS;AttachDbFilename=C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataAdventureWorks_Data.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"
providerName="System.Data.SqlClient" />
Guys
I am currently getting the error Cannot open user default database. Login failed.
Login failed for user '<user name>'. (Microsoft SQL Server, Error: 4064)
I took a backup of my Production Database but when I try to restore it I get this error. I cant do anything at the moment without getting this error.
Can you please help.
Hi,
I'm developing a windows forms app with a local database to be deployed on a couple of users machines. To aid deployment I'm using 'user instance' with a connection string of:
Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|gma.mdf;Integrated Security=True;User Instance=True;Connection Timeout=15;
I've started with a backup function based on the blog 'Backup and Restore with User Instance' linked to from this forum. Problem is I always get the error message 'Cannot open user default database. Login failed for user xxx'. This happens when I run in debugger or just run the exe directly.
Any help appreciated.
Dave
I work with Microsoft visual studio 2005.
i get data from a table by ADO.NET :
SqlConnection sqlConn = new SqlConnection(strConnectionString);
sqlConn.Open();
.....
it works fine.
but when i open the SQL Server 2005 express edition and connect to the server (inside the same computer) and run the code again ,the Open() function fails with the exception :
Cannot open user default database. Login failed.
disconnecting the server doesn't help and even closing the SQL Server 2005 application doesn't help.
Only restarting the computer enables the Open() command to work again.
Why ?
Hello, when I log onto Report Manager web server using Windows Authentication, I need this user to be directed to a default sub folder.
For example: if I have folder A and sub folder 1 and 2. I need to be able to log in and be directed to sub folder 1. I was able to set up view role and access folder A. But then I need to click on folder 1 to view / create my reports.
Hi,
I'm getting this error ever since I attached my VWD Express database to SQL Server Express. I detached the database after using it and closed SQL Server but as soon as I tried to run my application again in VWD I got...
Cannot open user default database. Login failed.Login failed for user 'xxxxxxxASPNET'.
I have tried attaching and detaching the database again in SQL Server with the 'Close Connections' check box ticked but still no joy. I have checked out all other posts on this subject but can't seem to find an answer that works for me.
Does SQL Server Express do something to users / permissions when attaching databases? It's all way above my head!
My connection string is as follows...
<add name="DatabaseConnectionString1" connectionString="Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|Database.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient"/>
Hey,I renamed a database, and it happened to be my default; so I basically screwed myself, because I can't change it through script (doesn't exist or you don't have permissions). What can I do? Thanks.
View 4 Replies View RelatedI have created an app which use sqlserver exrpress and works fine. I have now craeted a authentication page login.aspx.
I have added users successfully to the asp.net configuartion via the web site admin tool.
When I go to login using my page I get the Cannot open default database.Login failed. Login failed for user servetaspnet.
I have looked at the asonetdb in sql server management studio and the serverasp net is set up on the database.
Can anyone suggeste what I ma doing wrong or where I might see a work through of the problem.
Thanks
Frank
I am experiencing some login problems.
When I connect to SQL Server 2000 using SQL Server authentication I get error message error 4064, cannot open user default database. I can connect however if I use Windows Authentication.
The problem started when I did the ffg.
-backup sql db1
-restore db1 to another name (db2)
-drop db1
-use sp_detach
-use sp_attach to attach db2 as db1 (rename database)
When I connect in Query Analyzer via SQL Authentication I get the error, however via any other method it works fine.
Regards
Suhen
Yesterday was not my best day. I disconnected my database to make a copy of it and forgot to reconnect it before closing SQL Server 2000.
Now when I try ot access the database I get message.
Cannot Open User Default Database. Login Failed
Is there a way to attach the database again or a work around for this?
Thanks in advance for your help!
hi to all,
I am new to Sqlserver. in my machine i installed sqlserver2000.i created/registered a new server with sql authentication. but when i connecting it shows the login failed and i am unable to connect my database.after that i edited the server registration information as windows authentication. now it works well. what to do? how to tactic this problem? thanks in advance..
hi:
I got the problem, which lots of people might encounter before.
In my case, I use login control and sqlexpress to build a login page.
when password & user name were entered. It gave me:
"Cannot open user default database, login fails"
The solution given by msdn is:
SQL Server 2005You can use the sqlcmd utility to change the default database in SQL Server 2005. To do this, follow these steps: 1.Click Start, click Run, type cmd, and then press ENTER. 2.Use one of the following methods, depending on the kind of authentication that the SQL Server login uses: €˘If
the SQL Server login uses Microsoft Windows authentication to connect
to the instance, type the following at the command prompt, and then
press ENTER:sqlcmd €“E -S InstanceName €“d master€˘If
the SQL Server login uses SQL Server authentication to connect to the
instance, type the following at the command prompt, and then press
ENTER: sqlcmd -S InstanceName -d master -U SQLLogin -P PasswordNote InstanceName is a placeholder for the name of the SQL Server 2005 instance to which you are connecting. SQLLogin is a placeholder for the SQL Server login whose default database has been dropped. Password is a placeholder for the SQL Server login password.3.At the sqlcmd prompt, type the following, and then press ENTER: ALTER LOGIN SQLLogin WITH DEFAULT_DATABASE = AvailDBNameNote AvailDBName is a placeholder for the name of the existing database that can be accessed by the SQL Server login in the instance.4.At the sqlcmd prompt, type GO, and then press ENTER.
I wonder what are InstanceName, SQLLogin & AvailDBName. It would be nice if someone can give me a specific example, since I am not sure how to type them in a command line. :)
Hello,
I'm using Visual C# 2008 Express to connect to the Northwind database in SQL Server 2005 Express. My Visual C# project which worked yesterday now yields an exception on build.
The error message is:
Cannot open user default database. Login failed.
Login failed for user 'Plesva-PCPlesva'.
The connection string is:
Data Source=.SQLEXPRESS;AttachDbFilename="C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataNorthwnd.mdf";Integrated Security=True;Connect Timeout=30;User Instance=True
In SQL Server Management Studio Express, I can see that the default database for this Login is master. In the master database, the user mapped to this Login is 'Plesva-PCPlesva'. The database role membership for this Login in master is 'public'.
Does this have something to do with user instances? I'm not familiar with that topic, but have seen a few posts here and elsewhere that alluded to it. I couldn't make heads or tails of what they were talking about.
Thank you.
Cannot open user default database. Login failed.
Login failed for user '[machine name]ASPNET'.I'm working in VS 2005 with a starter kit. I close VS and open an MDF file in SQL Server 2005 Management Studio to modify a table. I attach the file, change a data type, then detach the file. When I go back to VS and try to run the program, I get this error. Everything runs normally before I bring the file into Management Studio. It is not a permissions issue. Does SQL Server put some kind of lock on the file? This must be a fairly common problem. A developer will sometimes want to modify an .mdf file. How does he do that and then run his program? Thank you for any suggestions I can try.
Hi,
I have installed SQL Server 2005 Express edition and when i try to run the web site as http://127.0.0.1/SiteName/Login.aspx. I am using default SQL Provider.
Can anyoone please help me??? i was struck here from last two days.
System.Data.SqlClient.SqlException: Cannot open user default database. Login failed.
Login failed for user 'XXXXXXASPNET'.
Regards,
Pradeep.
Hi
I am developing an asp.net application in Visual Studio 2005. The application was displaying in the web browser as expected but now i get the following error appear. Server Error in '/EMPRINT_STREETSIGNS1' Application.
Cannot open user default database. Login failed.
Login failed for user 'JEREMYLINTEROwner'.
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 'JEREMYLINTEROwner'.
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.
Stack Trace:
[SqlException (0x80131904): Cannot open user default database. Login failed.
Login failed for user 'JEREMYLINTEROwner'.]
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +171
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +199
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2300
System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +34
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +606
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +193
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +501
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28
System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +429
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +70
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +510
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +85
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +89
System.Data.SqlClient.SqlConnection.Open() +159
System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +118
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +139
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +83
System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +1657
System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) +13
System.Web.UI.WebControls.DataBoundControl.PerformSelect() +140
System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +68
System.Web.UI.WebControls.GridView.DataBind() +5
System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +61
System.Web.UI.WebControls.CompositeDataBoundControl.CreateChildControls() +67
System.Web.UI.Control.EnsureChildControls() +97
System.Web.UI.Control.PreRenderRecursiveInternal() +50
System.Web.UI.Control.PreRenderRecursiveInternal() +171
System.Web.UI.Control.PreRenderRecursiveInternal() +171
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5731
Visual Studio produces the same error when i try to connect to the
database unless i change the server to './SQLEXPRESS'.
why is the default user being changed to './owner' and how can i stop
this from happening?
Thank you
Hi,
View 37 Replies View Related
Hi,
I got this application system having SQLExpress as database (ABCSystem.mdf). I'm connecting to the database thru connection string specifying database path in App.config.
At the same time, I got two paths for the mdf files. The first one is the path for my database project while the second one is the path to conduct testing. (This means that I got identical ABCSystem.mdf in two paths)
1) C:Program FilesCompany ABCABCDatabaseProject
2) C:Program FilesCompany ABC LimitedABCSystemDatabase
In my development machine, I can run my application where database path is testing path (number 2).
When I tried to copy the ABCSystem.mdf and ABCSystem_log.LDF and my application program files to another PC to test, I got the subject error message. (note that I copy program files under directory "C:Program FilesCompany ABC LimitedABCSystem" and mdf files under "C:Program FilesCompany ABC LimitedABCSystemDatabase")
I try to edit path from database testing path to database project path in app.config, run the application, and notice that it is running OK.
What seems to cause the problem? Coz I need the database in the testing path which is "C:Program FilesCompany ABC LimitedABCSystemDatabase" AND NOT "C:Program FilesCompany ABCABCDatabaseProject".
Thanks alot for your kind attention.
I was wondering if there was a way to set a default project to open in Microsoft SQL Server 2005 when the application launches.
Perhaps there's a certain registry key I could edit?
Hi,We have 2 servers. Server1 is a 2000 box, with SP3 (yes I know it isnot up to date). Server2 is a 2005 box, SP2.I set up Server1 (2000) to have a linked server to Server2 (2005). Thereason I did this is because we are using a stored procedure onServer2 to send mail, as we have found that using mail on 2000 doesn'talways work as advertised.When I set up the linked server on the 2000 box, for security I justset it up to use a SQL Server user on the 2005 box. The SQL Serveruser on the 2005 box has permissions to run the stored procedure forsending mail.Here's the weird thing though. When calling the stored procedure onthe 2005 box from the 2000 box, sometimes we get an error that "Thedefault database cannot be opened", and the query does not run on the2005 box. However, it only happens *sometimes*. Other times, the queryruns fine.Since the problem seeemed to be with the default database, I changedthe SQL Server user on 2005 default database to the SAME database thatcontains the stored procedure.However, I just don't understand why it's even TRYING to open thedefault database, since when we called the linked server we are doingso as, and it's referencing the default database in the name:EXEC Server2.DefaultDatabase.dbo.StoredProcedureNameHowever, after changing the user's default database to"DefaultDatabase" as shown above, the query runs fine.Why are we having this problem? That is, if I change the defaultdatabase to something other than "DefaultDatabase", then the querydoesn't run, even though the database name is referenced in the abovequery??Obviously, this is not desireable, because that means we can only runqueries that are in "DefaultDatabase", which may not always be thecase.Thanks much
View 2 Replies View RelatedI just installed SQL Server 2005 CTP (9.00.1116) on Windows Server 2003 with SP1. Then I unzipped DotNetNuke portal site and tried to connect to it with various errors, generally relating to invalid login.
View 3 Replies View Related
I work with Microsoft visual studio 2005.
i get data from a table by ADO.NET :
SqlConnection sqlConn = new SqlConnection(strConnectionString);
sqlConn.Open();
.....
it works fine.
but when i open the SQL Server 2005 express edition and connect to the server (inside the same computer) to check something and then get back to the VS and run the code again ,the Open() function fails with the exception :
{"Cannot open user default database. Login failed.
Login failed for user 'DOMAIN\asaf_a'."
disconnecting the server doesn't help and even closing the SQL Server 2005 application doesn't help.
Only restarting the computer enables the Open() command to work again.
Why ?
I've tried everything I've read that seemed applicable but still have a problem with the same error message, cannot open user default database.
This started detaching the database.
I'm using this connection string:
connectionString="Data Source=.SQLEXPRESS;GC_CashBook.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"
It's a WinForms application.
When I run in debug mode, I connect fine. I can do anything in the db in VisualStudio 2005.
Then I open the SQL Management Studio, connect to Sql Express, try to open the same database and it can't open it.
BUT...
If I stop running the VisualStudio application (I can leave VS open, but not run the app I'm developing),
and reopen SQL Management Studio, connect to Sql Express and open the same db, I can do anything.
It's not just VS and SQL either.
If I open CodeSmith and load a template I use that access the db, I can run my templates fine as long as I'm not running the application in VS or have the db open in SQL Express.
In other words, I can have one connection at a time only on this sql express db.
Before I detached it, I could have multiple connections at the same time.
I checked the properties in sql express and it says I can have multiple (4 is specified) connections at a time;
Allow remote access is also checked.
Arrow/Rick is db owner, the default database is Master.
I don't know any other information to provide.
DId I miss something? How can I get multiple connections working again on this?
Any help would be appreciated!
Cannot open user default database. Login failed.Login failed for user
'NT AUTHORITYNETWORK SERVICE'. 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 'NT AUTHORITYNETWORK SERVICE'. I have This Error When i try to log into My online web site, i have no idea how to fix it,one day it was working and the next it wasnt, is there any way to find out what database the default is and if it's either incorrect or not present change the web.config in a way that will make my system work. i have the NT Authority/Network Service in my Server Properties Permissions, its given the type login and is granted Connect SQL by sa i have 3 colder copies of the web site on my server my question is, how would i use of of these to restore the original site configuration is there a way to restore the original configuration to undo whatever it is i've done to break the system ChrisStressed
Hi, I'm new to SQL Express 2005.
I found information regarding : "Cannot open user default database. Login failed."on this forum but I think that in my case it's a bit different issue.
I have a website (ASP.NET 2.0) accessing DB, in the mean time Windows Service tries to update some data in the same DB (Service runs as NT AUTHORITYLOCAL SYSTEM). The second connection is rejected: "Cannot open user default database. Login failed.Login failed for user ....".
Problem occurs only when both: service and website are running at the same time. So service and website are running without problems when they are connecting DB exclusively.
My connection string is:
"Data Source=.SQLEXPRESS;AttachDbFilename="|DataDirectory|spider-lab.mdf";Integrated Security=True;User Instance=True"
I would be grateful if you can help me