ConnectionString is below.
Dim objDb As New SqlConnection("Data Source='(local)';trusted_connection=true;Initial Catalog=classdb")
This ConnectionString occurs DB-Open-Error. Why?
Show me the Solution.
what xactly is the error message ?
Try this url for samples. Hope this helps.
http://www.carlprothman.net/Default.aspx?tabid=81
I have created a new database within SQLServer Express 2005 and have an ASP page in IIS. Any time i attempt to access the database I get the following error:
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database "testDB" requested by the login. The login failed.
The ODBC connection that I have created works fine if connecting to the same table (literally three sample fields with two records) in an Access database.
The database connection that I am using is:
Set DatabaseConnection = Server.CreateObject("ADODB.Connection")
DatabaseConnection.Open "DSN=testDB;UID=EINSTEIN\Administrator&pwd=password;DATABASE=testDB;APP=ASP Script"
Set rs = Server.CreateObject("ADODB.recordset")
SQLString = "SELECT * FROM testTable"
rs.Open SQLString, DatabaseConnection
if NOT rs.EOF then
Response.Write(rs("testField1") & " - " & rs("testField2"))
end if
rs.Close
DatabaseConnection.Close
Set DatabaseConnection = Nothing
EINSTEIN is the name of the server, rs = Recordset. I have tried changing to just Administrator instead of machinename\Administrator with no success. I have got SQL Server Management Studio Express CTP, and can log in fine to SQL Server using EINSTEIN\Administrator.
Please can anyone help!
Suggesting that you are going the DSN-less way (Connectionstrings can be found here www.connectionstrings.com) the database which is requested is not available for this user. You cannot provide a Windows User name if you want to use trusted authentication (it some time ago, that I used DSN, but I guess this is just possible for passing over SQL Server authentication. Try using a DSN-less connection with specifying a database that is accessible for the user.
See if that works, Jens Suessmeyer.
|||It looks like your connection string may be a little incorrect, the current string is:
"DSN=testDB;UID=EINSTEIN\Administrator&pwd=password;DATABASE=testDB;APP=ASP Script"
It should be
"DSN=testDB;UID=EINSTEIN\Administrator;pwd=password;DATABASE=testDB;APP=ASP Script"
No Ampersand between Administrator&pwd, instead it should be a semi-colon
See if that works
<connectionStrings>
<addname="NorthwindConnectionString"
connectionString="Data Source=.\sqlexpress;Initial Catalog=Northwind;Integrated Security=True"
providerName="System.Data.SqlClient"/>
</connectionStrings>
<asp:GridViewID="GridView1"runat="server"AutoGenerateColumns="False"DataKeyNames="CategoryID"
DataSourceID="SqlDataSource1">
<Columns>
<asp:BoundFieldDataField="CategoryID"HeaderText="CategoryID"InsertVisible="False"
ReadOnly="True"SortExpression="CategoryID"/>
<asp:BoundFieldDataField="CategoryName"HeaderText="CategoryName"SortExpression="CategoryName"/>
<asp:BoundFieldDataField="Description"HeaderText="Description"SortExpression="Description"/>
</Columns>
</asp:GridView>
<asp:SqlDataSourceID="SqlDataSource1"runat="server"ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString %>"
SelectCommand="SELECT [CategoryID], [CategoryName], [Description] FROM [Categories]">
</asp:SqlDataSource>
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. |
|
i was using .net's internal server as a my web server(local)
now i have changes it to IIS(local)
but now i amgetting an error like
Cannot open database "mydatabse" requested by the login. The login failed.
Login failed for user 'SV2\ASPNET'
'SV is my achine name ASPNET is a login in the directory in seccurity/logins in sql server management studio
what can i do?
Hi,
Are you sure you have given the machinename\aspnet account the required permissions
http://forums.asp.net/p/905865/1001573.aspx
At times, adding <identity impersonate="true"/> to the web.config helps you to impersonate the user acccessing the application
Also check your connection string.
HTH,
Suprotim Agarwal
--
http://www.dotnetcurry.com
--
Is your database on a different machine than your web server? If so, you need to give the account that the web application is running under access to the database.
|||Hi,
Your connection string is set to use windows authentication or logged in user credentials, either change it to use SQL username password.
I am trying to install Sql Server 2005 June CTP on a Windows Server
2003 SP1 primary domain controller with IIS/ASP installed.
I get this error (when Sql Server Database Services is being installed:
"SQL Server Setup was unable add user NT AUTHORITY\NETWORK SERVICE to
local group SQLServer2005MSSQLServerADHelperUser".
And I am not alone!
See http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=18788
Any workaround or update to be able to install it on a domain controller, Microsoft?
Thanks!
Anybody?Our environment requires installation of SQL 2005 on a server with Active Directory... so this is really a big issue.
Please, can somebody from MS look into this?|||We are a few days later now, and still, nowhere on the Internet I can find a solution.
Can somebody from Microsoft please respond?|||
Currently SQL Server 2005 will not install on a Domain Controller or on Windows Small Business Server. There is no known work around at this time other than installing on a machine that is not configured as a domain controller. This is a known issue and we're working on resolving it.
Dan
|||Yikes, this is a huge issue. I have this issue too on a single Win2K3 Server Standard with SP1, AD/DC. Active Directory and DC are required before setting up TFS.
RDA.Pull method is not doing anything for me from a VSTO 2005 Outlook addin project. I have IIS & SQL Server 2005 running on my develpoment pc. I am using Integrated Windows Auth for vdir. It just stops execution at the line of code that calls RDA.Pull & doesnt return any tables nor throws an error. I have no idea where I am going wrong. I have tried using table names that dont exist in the .sdf too.
SqlCeRemoteDataAccess rda = new SqlCeRemoteDataAccess();
rda.InternetUrl = @."http://localhost/WsRDA/sqlcesa30.dll";
rda.LocalConnectionString = @."Data Source=D:\_fullPahtHere\DBEverywhere.sdf;Password=sdfPwdHere";
rda.InternetLogin = "myLocalUserName";
rda.InternetPassword = "myLocalPassword";
rda.Pull("Class2", "select * from dbo.Class", @."Data Source=MyDesktop\SQL2K5;Initial Catalog=ServerDB;Integrated Security=SSPI");
Without an error msg, I dont know what the problem is. Any ideas?Ok, figured out. My connection string was missing Provider=sqloledb attribute.
