Help. Problem Connecting To SQL Server Database
Dec 6, 2003
Hi,
I am having trouble connecting to my sql server database. I get the follwoing message when I tried to connected through a stored procedure
Insert Failed. Error Details are: System.Data.SqlClient.SqlException: Login failed for user 'merlin'. Reason: Not associated with a trusted SQL Server connection. at System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) at System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) at System.Data.SqlClient.SqlConnection.Open() at ASP.insertvcds_aspx.AddJAV(Object sender, EventArgs e) in
I checked the merlin user and he is a user in the database with all priviledge granted to the database. What steps can I check to make sure in sql server enterprise manager to make sure it works.
Thanks,
John
View 1 Replies
ADVERTISEMENT
Sep 13, 2001
I have the following error and need help!!
Microsoft OLE DB Provider for SQL Server error '80004005'
[DBNMPNTW]Specified SQL server not found.
This is my coding causing the problem:
Dim conn
Dim SQL
Dim R
Dim RecsAffected
Dim aConnectionString
aConnectionString = "Provider=SQLOLEDB;Data " _
& "Source=(local);Database=Experiment;" _
& "UID=sa;"
Set conn = Server.CreateObject("ADODB.Connection")
< !--#INCLUDE FILE="<C:Program FilesCommon FilesSystemadoaadovbs.inc" -- >
conn.Mode = adModeRead
conn.ConnectionString = aConnectionString
conn.open
Do I need to set anything up in SQL Server first?
Thanks in advance for any help!!!
View 1 Replies
View Related
Jul 14, 1999
Hi,
I'm creating ASP that should run stored procedure on SQL server. I need to set up System DSN, right? When I logged on to the web server as some NT user (which is administrator for web server and has read permissions on the SQL server) - I successfully created the DSN. When I logged on to the server as Internet anonymous account (we use IIS 4.0, so it is IUSR_SERVER-NAME), I was not be able to set up the DSN, though I did the same as previously. This means that we don't have appropriate permissions for web server Internet anonymous, right? So question number 1: can it be set up read permissions on SQL server for local user from web server with the name IUSR_SERVER-NAME?
I now that a user can be set on SQL and I can use it's id while setting up the DSN (while doing this I need to choose "SQL Server Authentication" and provide user id and password, correct?). I tried this way as well -- when then I use the set DSN in ASP file I still have the "Not defined as a valid user of a trusted SQL Server connection" error in my browser. So question number 2: How to set up system DSN and provide in it SQL server's user id and password?
Or may be the problem is that I use stored procedure and need different type of permission?
I would appreciate if you aswer all the questions or give me explanation on the problem.
Thanks,
Erik T.
View 2 Replies
View Related
Aug 4, 2002
I have a server from a hosting company and they have so many databases on the server that it crashes my enterprise manager. So what I am looking for is a way to connect to only my database on that server. The tech support said to create a dsn and connect that way. Well i can do that with ms access, but I would prefer to use enterprise manager. Is there any way to set this up so all I get connected to is my database and not have to list all the databases on the server?
Any help with this would be great and if you can email me I would appreciate it.
Thanks a bunch for any help with this.
View 1 Replies
View Related
Jul 17, 2006
Hi,
I'm new to SQLExpress, and I need some help. I am trying to create a SQL database that will sit on a shared server in our organisation. I go into SSMSE and click on New Database which takes me to the New database screen. I now want to change the default path name to our server name, but when I click on the Locate Folder button (...), it only allows me to select folders from my Local drive. Is this a limitation of SQL Express, is there a way around this...?
Thanks in advance...
View 3 Replies
View Related
Nov 17, 2006
Hi
I've been using the new features with ASP.Net 2 for some months now. I use the gridview control a lot with the sqldatasource. I recently started a new job and am having problems connecting a sqldatasource control to a sql server 7 database. At my old job we used sql server 2000.
I get the error: "SQL server version needs be 2000 or higher" when I try to set up a new connection.. I read some documentation that said you can use asp.net 2 datasource controls with sql server 7. Does anyone know how to get round this issue. I don't want to have to go back to 1.x methods of connecting data controls to databases using code.
Thanks
View 1 Replies
View Related
Jan 31, 2007
I am developing a system using VS 2003 with database SQL Server 2000.
In web.config, I have added the following code in it
<sessionState
mode="InProc"
stateConnectionString="tcpip=127.0.0.1:42424"
sqlConnectionString="data source=127.0.0.1;Database=grandb;Trusted_Connection=yes"
cookieless="false"
timeout="60"
/>
Actually I don't know if the above code is correct. My database is stored in the SQL Server 2000 and named as grandb.
Thank you.
View 3 Replies
View Related
Oct 18, 2007
Hi,
I am getting the following error when i am trying to connect to the database server installed on different box.
"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)"
When i searched google, some postings suggested to enable the TCP/IP and Named Pipes Protocols from SQL Server configuration Manager. I did so and also ran mofcomp command. But even after doing this i am not able to connect to the server. Following is my connection string.
<add key="conn2" value="Data Source=xxxxxxxx;Initial Catalog=xxxxxx_xxxxxx;User ID=xx;Password=xxxxxx;"/>
Could any one please tell me what else the configuration settings i need to do in order to connect to the database from my application.
View 1 Replies
View Related
Jan 12, 2005
Hello all,
I have been having problems lately in trying to connect my ASP.Net page to an SQL Server 2000 database. I downloaded and already installed the 120-trial of SQL Server 2000. I have already made a database for a project that I am working on.
****
Here is the code from the ASP.Net page that I created to test and see if I can connect to the database.
****
<%@ Page Language="VB" Debug="true" %>
<%@ import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<Script Runat="Server">
Sub Page_Load
Dim conPubs As SqlConnection
conPubs = New SqlConnection( "server=localhost;uid=;pwd=;database=TuneIn" )
conPubs.Open()
End Sub
</Script>
Connection Opened!
****
Here is the error that I am getting.
****
Server Error in '/ASPnet' Application.
--------------------------------------------------------------------------------
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
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: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
Source Error:
Line 9:
Line 10: conPubs = New SqlConnection( "server=localhost;uid=;pwd=;database=TuneIn" )
Line 11: conPubs.Open()
Line 12: End Sub
Line 13:
Source File: C:InetpubwwwrootASPnetecommerceconnect.aspx Line: 11
Stack Trace:
[SqlException: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.]
System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) +484
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) +372
System.Data.SqlClient.SqlConnection.Open() +384
ASP.connect_aspx.Page_Load() in C:InetpubwwwrootASPnetecommerceconnect.aspx:11
System.Web.Util.ArglessEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +10
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +750
I hope this is not a dumb question, but how and where can I find out what the UserID (UID) and/or my Password is so I can connect my ASP.Net page to my database, because I do not ever remember putting a UID and/or a password when I installed SQL Server 2000???? In the ASP.net code above, I purposely did not put a UID and a password because I am not sure what to put there.... :-( ... Have I missed something somwhere?!?!?!?
Any help and or assistance will be greatly appreciated!! I have been trying for a week to figure out what is wrong, and I need help....PLEEEEEASE!!!
Thanx in advance!!!!
CAOTK
View 3 Replies
View Related
Aug 3, 2005
I am having a problem connecting with a database on my server.Please look at my following code: sub Page_Load(Sender as Object, e as EventArgs) dim myConnection As SqlConnection dim myCommand As SqlDataAdapter myConnection = New SqlConnection("server=XX.XXX.XX.XXX;database=Northwind;Trusted_Connection=Yes;userid=JoeSilla;password=XXXXXXX") myCommand = New SqlDataAdapter("SELECT * FROM Products", myConnection) Dim ds As DataSet = New DataSet() myCommand.Fill(ds, "Products") MyDataList.DataSource = ds.Tables("Products").DefaultView MyDataList.visible = true MyDataList.DataBind() end subPlease let me know if there is any problem with my code.
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. 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: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.Source Error:
The source code that generated this unhandled exception can only be shown when compiled in debug mode. To enable this, please follow one of the below steps, then request the URL:1. Add a "Debug=true" directive at the top of the file that generated the error. Example: <%@ Page Language="C#" Debug="true" %>or:2) Add the following section to the configuration file of your application:<configuration> <system.web> <compilation debug="true"/> </system.web></configuration>Note that this second technique will cause all files within a given application to be compiled in debug mode. The first technique will cause only that particular file to be compiled in debug mode.Important: Running applications in debug mode does incur a memory/performance overhead. You should make sure that an application has debugging disabled before deploying into production scenario. Stack Trace:
[SqlException: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.]
System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction)
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction)
System.Data.SqlClient.SqlConnection.Open()
System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState)
System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable)
ASP.WebForm1_aspx.Page_Load(Object Sender, EventArgs e) in c:inetpubwwwrootday%208DataTestWebForm1.aspx:14
System.Web.UI.Control.OnLoad(EventArgs e)
System.Web.UI.Control.LoadRecursive()
System.Web.UI.Page.ProcessRequestMain()
View 1 Replies
View Related
Jun 29, 2007
Hi,
I have a msaccess linked server that I use to execute sql 2000 stored procedures from a front end in adp (access data project) format without any problem, if it is used on the same machine where the sql server resides (with any user logged on). In any other machine on the local network where I also need to use it, I get an ole/db error message saying that the microsoft jet database engine can not open the file because it's allready opened exclusivly or because it do not has permissions. I created the linked server with both UNC and normal path with the same result.
Thank's for all the help/clues you can give me.
View 4 Replies
View Related
Mar 11, 2008
Hello,
i tried to connect to a SQL Server Compact Database (version 3.5) with SQL Server Management Studio Express (Version 9.00.3042.00).
But i get the follwing error message (sorry, it's a german message):
.....................................
Es kann keine Verbindung mit 'D:DocumentsVisual Studio 2008Projects\_ProduktivSuperkalibrator_PrototypenSuperkalibrator_PrototypenDatenbankDatabaseTest.sdf' hergestellt werden.
------------------------------
ZUSÄTZLICHE INFORMATIONEN:
Sie versuchen, auf eine ältere Version einer Datenbank von SQL Server Compact Edition zuzugreifen. Falls es sich um eine Datenbank von SQL Server CE 1.0 oder SQL Server CE 2.0 handelt, führen Sie 'upgrade.exe' aus. Falls es sich um eine Datenbank von SQL Server Compact Edition 3.0 oder höher handelt, führen Sie die Komprimierung und Reparatur aus. [ Db version = 3505053,Requested version = 3004180,File name = D:DocumentsVisual Studio 2008Projects\_ProduktivSuperkalibrator_PrototypenSuperkalibrator_PrototypenDatenbankDatabaseTest.sdf ] (SQL Server Compact Edition ADO.NET Data Provider)
.....................................
Is there a solution to manage Compact Databases in Version 3.5?
Thanks!
Stefan Wagner
View 4 Replies
View Related
May 30, 2008
hi all,my hosting company uses a different port for connect to their sql server.how do i register a server in sql server management studio with a different port number??
View 3 Replies
View Related
Mar 8, 2006
Newbie strikes again.. I'm attempting to connect to a SQL Server database (using VS 2005). My code generated no errors in the build but when I tried to access the database, I got the following message:"The ConnectionString property has not been initialized."My connection string is stored in my web.config file. My code goes as follows:Dim strSQL As String = "SQL string stored here"Dim objConnection as SqlConnection = New SQLConnection(ConfigurationManager.AppSettings("name of connection string is here"))Dim objCommand as SQLCommand = New SqlCommand(strSQL, objConnection)objConnection.Open()Then I go on to open my reader and such. Where should I be initializing the ConnectionString property?TIA,Lesley
View 1 Replies
View Related
Jun 14, 2001
I am interesting in knowing how to connect to database files that are not kept local to the SQL server? If you have any familiarity w/ this, can you please help me out w/ some information.
Thanks.
View 2 Replies
View Related
Jan 10, 2001
I am a new SQL Server developer using Visual Basic 6 Professional Edition. I am using ADO and SQLDMO to develop my application. The SQL Server is Version 7.0, SP2 and SP3 (two different servers).
I am having difficulty gaining access, using ADO, to databases I create using SQLDMO. I create the database, create the DBFILE object, create a login and attach it to the database, create a user, assign the created login to the user,
and assign the created user to the 'db_datareader', 'db_datawriter' and 'public' roles. the login object was set to 'standard', not NT. the SQL Server is set to 'mixed' NT -SQL Server login mode. Thw SQL Server is running under the 'system account'. Using SQL Server Enterprise Manager, everything looks OK. An attemp to connect using the ADO connection object fails, giving an error of Login failed for user 'engbom3admin'.
Connecting to the SQL Server using SQLDMO uses the 'sa' user name with a blank password.
I can successfully connect to the created database using the ADO connection object using the 'sa' user name and blank password. Using the SQL Server Enterprise manager, I cannot see anything at all different between the 'sa' and my created 'engbom3admin' user. I've manually set the created user to have 'db_owner' roles, etc. Same result. I'm stumped. I've read all I can gather from the Microsoft SQL Server books. I'm still stumped.
I would greatly appreciate any help, information or tips you could provide. Thank you in advance.
Sincerely,
Bob Wohlers
SVP, IS Datamax Corporation
View 2 Replies
View Related
Aug 3, 2006
Hi everyone,
I created a database in SSMS,but I can't connect to it using VB Express code.When I delete the database name from the server I can connect to server,but when I mention the name of the database or initial catalog,I receive a login failure error for the mentioned database...
My connection string is:
Dim conn1 As SqlConnection = New SqlConnection("Data Source=.SQLEXPRESS;initial catalog=TEST1;" _
& "Integrated Security=True;" & "user instance=true;")
Everything is Local,I am using express version of SQL server and VB.How I am not be able to connect the database I created under the server in SSMS...I am really confused...
Thanks in advance!!!!
Can
View 8 Replies
View Related
Jul 1, 2006
hi
i have created a sql database in visual studio pro and now i would like to connect to that database in SQL server managamenet studio. so when i start SQL server i connect to the same instance as my database (wich is .SQLEXPRESS) but i can't find my database in the object explorer?
View 1 Replies
View Related
May 16, 2008
I've just installed a 365-day trail of microsoft SQL Server 5.0 Development edition and want to connect to a database in the database engine. I've checked that the services are running under My Computer->Manage->Services and Applications->SQL Server Configuration Manager and the SQL Server, SQL Server Agent msftesql and SQL Browser services are all running.
When I try to connect to my database, I get the following error:
InternalsVisibleTo declarations cannot have a version, culture, public key token, or processor architecture specified. (ObjectExplorer)
The start of this message is prefixed with:
C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.SmoEnum9.0.242.0_89845dcd8080cc91Microsoft.SqlServer.SmoEnum.dll
What on earth does all that mean? And how to I fix it so I can connect?
Cheers,
- Blue.
View 1 Replies
View Related
Oct 21, 2006
Hi,
I have setup a linked server to a DB2 database using "Microsoft OLE DB Provider for ODBC Drivers",
the connections works fine i am able to run select queries.
but the number of rows returned from the two following statements are different.
select * from linkedserver...tablename
select count(*) from linkedserver...tablename
e.g. The First statement returns 116 rows, whereas the second query returns count as 144....
I am a bit confused ?????
could anybody think of any possible reasons..
Cheers
ARAW012
View 4 Replies
View Related
Oct 4, 2006
Hey All,
I am having a problem connecting to a database I have with a java app I am creating for my senior project. I am using the latest MS JDBC for connecting to the SQL Server.
Below is the code I am trying to run:
try {
ds.setIntegratedSecurity(true);
ds.setServerName("localhost\SQLEXPRESS");
ds.setDatabaseName("*databasename*");
con =ds.getConnection();
} catch (Exception ex) {
ex.printStackTrace();
}
The ds and con variables are declared and initialized correctly. The error I am getting now is this:
com.microsoft.sqlserver.jdbc.SQLServerException: Cannot open database "*databasename*" requested by the login. The login failed.
Any suggestions on what I could be doing wrong?
View 4 Replies
View Related
Jan 22, 2008
I've run into a bit of a database connection problem. I'm trying to connect to a SQL Server database. It compiles okay, but then while IE is loading, I get an exception error pointing out in the code saying 'Keyword not supported: 'provider'.
View 2 Replies
View Related
Sep 6, 2003
Hello Guys,
I have just put up an Webserver with SQL Server 2000. Everything is working fine on the remote machine Thru TS .. i can do every administrative things .. But i m facing problem to connect my remote databse server thru the Enterprise Manager .. It Gives me Cant Connect Database Server " Connection Failiure " when i try to connect my remote database server thru Ip address ,.. Please some one help me out to make connecting database server thru Enterprise Manager ..
Thanks
View 10 Replies
View Related
Jun 26, 2006
Is this possible to connect do the Database Engine (on sql server 2005 on XP platorm - file *.mdf (not mobile *.sdf)) from win CE 5.0?
I tried to do this :
ConnectionStringSQLServerCE = "Data Source=WORK_STATION\SQLEXPRESS;Initial Catalog=dbMachines;Integrated Security=False;Password=Panel;User ID=Panel";
SqlCeConnectionCE = new SqlConnection(ConnectionStringSQLServerCE);
SqlCeConnectionCE.Open();
but I catch error:
catch (PlatformNotSupportedException ex)
€žPlatformNotSupportedException€?
I noticed that I see server because when I use:
ConnectionStringSQLServerCE = "Data Source=WORK_STATION\SQLEXPRESS";
zwraca błąd typu
catch (SqlException ex)
€œLogin failed for user ''. The user is not associated with a trusted SQL Server connection.€?
I used
using System.Data.SqlClient;
from Compact Framework 2.0 under Visual Studio 2005 Device Application Windows CE 5.0
can anyone help me?
View 1 Replies
View Related
Nov 2, 2007
I am having problems connecting to the database. I am trying to use Membership API and for some reason it will no longer connect to the database. I previously had Visual Studio 2005 Standard Edition and it worked just fine, until I tried to install MS SQL Express. I have tried the aspnet_regsql and sqlcmd InstallCommon.sql and both times I received a named pipe error. I look at the configuration and it said named pipes enabled.
I eventually gave up after trying for two days and removed MS SQL Express, but now I am still getting the same error. I tried to uninstall all of the SQL editions and reinstall the MSDE that comes with VS 2005, but I am getting the same error.
When checking the ASP.NET Web Application and testing the provider I receive the following error:
Could not establish a connection to the database.
If you have not yet created the SQL Server database, exit the Web Site Administration tool, use the aspnet_regsql command-line utility to create and configure the database, and then return to this tool to set the provider.
The security tab gives you the following error:
There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to a page where you can choose a new data store.
The following message may help in diagnosing the problem: Unable to connect to SQL Server database.
Running the sqlcmd in the command prompt I receive the following error:
Sqlcmd: Error: Connection failure. SQL Native Client is not installed correctly. To correct this, run SQL Server Setup.
I just Visual Studio to work correctly again.
Thanks,
R
View 1 Replies
View Related
Nov 3, 2006
I want to use SQL Server to query an Access Database with about 40,000 rows of data. If possible, I don't want to upsize the database because others need acess to it in the ACC97 format. Is there a way to use ODBC to connect to the ACC97 database so that I can use the SQL query capability of SQL server to query the database.
I know access allows you to write some SQL queries but I need the power of the SQL server and now it is a matter of curiosity because I've been searching for this answer for about 8 hours.
View 1 Replies
View Related
Mar 18, 2008
I have a very basic console application whose sole purpose is to query a database on the same local computer. When i run the application, i get the error message below:
Cannot open user default database. Login failed.Login failed for user 'someDomainSomeUserName'.
Below is my connection string also
myconnection_string = New SqlConnection("Data Source=.SQLEXPRESS;AttachDbFilename=C:Reporting SystemApp_Datasafetydata.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True").
After some googling, some post pointed to deleting a user folder at :
C:Documents and SettingsmyusernameLocal SettingsApplication DataMicrosoftMicrosoft SQL Server DataSQLEXPRESS
but still deleting that folder and restarting the machine doesn't help and i also have remote connections enabled. Help is really needed.
NOTE: The same application runs on a different computer with XP but fails on the Pc with windows server 2003.
View 3 Replies
View Related
Mar 20, 2008
I've had some problems with Reporting Services and getting connected to the database server after configuration. I am now getting the following error message:
The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. (rsReportServerDatabaseUnavailable) (rsRPCError)
In my Database Setup everything runs fine when I click apply except for the Setting Connection Info for Reporting Server this has a yellow triangle with a ! and says that the report server cannot access internal information.
I also have not been able to Initialize as there are no instances to initialize and none are created when I go through setup. Is there something I need to delete from the registry or the file system that does not get removed upon uninstall?
Thanks.
Emily
View 11 Replies
View Related
Feb 14, 2008
Hi all,
In the VB 2005 Express, I can get the SqlConnection and ConnectionString of a Database "shcDB" in the Object Explorer of SQL Server Management Studio Express (SSMSE) by the following set of code:
///--CallshcSpAdoNetVB2005.vb--////
Imports System.Data
Imports System.Data.SqlClient
Imports System.Data.SqlTypes
Public Class Form1
Public Sub InsertNewFriend()
Dim connectionString As String = "Data Source=.SQLEXPRESS;Initial Catalog=shcDB;Integrated Security=SSPI;"
Dim connection As SqlConnection = New SqlConnection(connectionString)
Try
connection.Open()
Dim command As SqlCommand = New SqlCommand("sp_insertNewRecord", connection)
command.CommandType = CommandType.StoredProcedure
.......................................
etc.
///////////////////////////////////////////////////////
If the Database "shcDB" and the Stored Procedure "sp_inertNewRecord" are in the Database Explorer of VB 2005 Express, I plan to use "Data Source=local" in the following code statements to get the SqlConnection and ConnectionString:
.........................
........................
Dim connectionString As String = "Data Source=local;Initial Catalog=shcDB;Integrated Security=SSPI;"
Dim connection As SqlConnection = New SqlConnection(connectionString)
Try
connection.Open()
Dim command As SqlCommand = New SqlCommand("sp_insertNewRecord", connection)
command.CommandType = CommandType.StoredProcedure
........................
etc.
Is the "Data Source=local" statement right for this case? If not, what is the right code statement for my case?
Please help and advise.
Thanks,
Scott Chang
View 6 Replies
View Related
Apr 9, 2008
I've a 32 bits application that runs on 64 bits Windows Server+MS-SQL.
I've created an ODBC DSN using c:WindowsSysWow64odbcad32.exe.
Sp, the program recognize the ODBC but having problem connecting.
The error look likes this:
***
[Microsoft][ODBC SQL Server Driver][SQL Server]Could not find server '<name>' in sys.server. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers.
***
Any help is appreciated.
Regards,
Ben
View 1 Replies
View Related
Apr 23, 2008
Hi all,I come up with a problem aleady discussed in some posts especially in the post http://forums.asp.net/t/1235761.aspx. but I got in not finally solved.The main problem is connecting to a database twice which causes errors. So I think this might be the right place to ask my questions. Here ist the problem in short:I'm using VWD on XP-Professional with SQL-Server Express and Reporting Services Express. All with Windwos Integrated Security and User Instance (SQLExpress). In my web-application I had for all Datasources the connect string:Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|mydatabase.mdf;Integrated Security=True;User Instance=True This works fine so far. I also have Reports designed with the Report designer using the same connection string. I can preview the reports and I deployd thre reports successfully. I want to call these report using a report viewer web control.Now the problem:when I call the remote remote report from my web-application, the database cannot be opened because an other process is using the database (see post mentioned above). It seems that this is a problem with attaching the database twice: from the sql-server and from the report-server.So I used now a new connection string without "attaching" the database (in vwd and in report designer):Data Source=.SQLExpress;Initial Catalog=C:inetpubwwwrootmyappAPP_DATAmydatabase;Integrated Security=True Now everything works...but ... only on my machine. On the production machine this does not work. I wonder anyway, why its working on my machine, because I never "attach" the database (there is no connection string with AttachDbFilename and I have not opend the developer and have not opened the sql management studio).On the production machine the concurrent (SQL-Server and Report-Server) connection to database does not work with either connection strings, no matter if i attach the database with sql server manager or not).This all drives me crazy for days now. All I want is to use SQL-server and Reporting- Services with its nice features and not repairing my tools. I thought I have a standard Installation, nothing special, but the standard obviously makes problems.Here finally my question:Does this environment ( web-application with remote reports) with Express edition cause normally no problems?Can I "attach" a database only once? How should I connect with my web application that uses the sql-server connections and also the report-server-connections (attaching twice does not work).What connection strings to use and when (AttachDbFilename or Initial Catalog).Are these problems specific to the Express Editions? I thank you in advance for any help Dieter
View 2 Replies
View Related
Sep 24, 2007
I am very new to web development using Microsoft Visual Studio. (my primary expertise is Framemaker 2003). I am currently going through your ASP.NET 2.0 videos and reproducing the lesson content on my development system. I have Microsoft Visual Studio 2005 Professional Edition. I also have Microsoft SQL Server 2005, Microsoft SQL Server 2000, Microsoft .NET Framework SDK v1.1 and Microsoft .NET Framework SDK v2.0.
I seem to be having difficulties with the SQL interface because when I try to use the Property object from Lesson04, I get System.Web.HttpExceptioon {"Unable to connect to SQL Server database."}. When I subsequently tried to Add New Item - SQL Database from Lesson08, I get a Microsoft Visual Studio error box "Connections to SQL Server files (*.mdf) require SQL Server Express 2005 to function properly. Please verify the installation of the component or download from the URL: http://go.microsoft.com/fwlink/?LinkId=49251"
Any ideas? I know the videos are based on use of the Microsoft Visual Studio Express -- are there significant configuration differences between it and Microsoft Visual Studio Professional that would make these lessons incompatible?
View 10 Replies
View Related
Sep 26, 2007
Using web dev and sql 2005 express
I have published web app and database to my server but can,t get connection string to connect with the database.
---------------------------------------------------------------------
Login failed for user ''. The user is not associated with a trusted SQL Server connection.
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: Login failed for user ''. The user is not associated with a trusted SQL Server connection.
---------------------------------------------------------------------
I have created a user in the logins in the sql server security node and give him every permission
going.
I have also created a login in the security node for the database..... and given him all permissions
But I still can,t get the connection string from the web app to connect to the database?
Where am I going wrong
View 5 Replies
View Related
