How To Get The Catalog Name For The SQL Server Without Connection String

May 1, 2008



how to get the catalog name for the SQL server without connection string
through the front end is that possible

View 7 Replies


ADVERTISEMENT

Initial Catalog Faulty In Connection String - Why?

Jul 26, 2007

Hi there, I am in the process or deploying our existing .NET 1.1 application together with its SQL Server 2000 databases to 2 new hardware platforms (one for databases and one for application). I have transferred the databases and installed the application (using our installers). I have tested the database logins and checked the database user rights - everything is fine - or so it appears to be. However, when I try to open the application it receive the following exception
[Exception: Data Source=172.16.7.1;Persist Security Info=False;UID=myAccount; password=myPassword;Connect Timeout=60;;Initial Catalog=http://xxx.xx.x.x/directory/myPage.aspxMYDATABASE;Pooling = 'false';Application Name=WEBAPP; System.Data.SqlClient.SqlException: Cannot open database requested in login 'http://xxx.xx.x.x/directory/myPage.aspxMYDATABASE'. Login fails.
Login failed for user 'myAccount'.
at System.Data.SqlClient.SqlInternalConnection.OpenAndLogin()
at System.Data.SqlClient.SqlInternalConnection..ctor(SqlConnection connection, SqlConnectionString connectionOptions)
at System.Data.SqlClient.SqlConnection.Open()
at FrameWork.DataServices.DBConnect.GetInternalConnection(Int32& icnt)]
FrameWork.DataServices.DBConnect.GetInternalConnection(Int32& icnt) +655
FrameWork.DataServices.DBConnect.GetInternalConnection() +16
FrameWork.Components.DBComponent.get_m_SqlConnection() +59
FrameWork.Components.DBComponent.ExecuteReader(SqlCommand cmd, Int32 iRetry, Boolean bIgnorecase) +53
FrameWork.Components.DBComponent.ExecuteReader(SqlCommand cmd, Boolean bIgnorecase) +337
FrameWork.Components.DBComponent.ExecuteReader(SqlCommand cmd) +7
It appears as if my ADO connection string is faulty. If a manually connect using a connection string in the format I expected it to be, everything works. Here are my manual connection string:
 Data Source=xxx.xx.x.x;Persist Security Info=False;UID=myAccount; password=myPassword;Connect Timeout=60;;Initial Catalog=MYDATABASE;Pooling = 'false' What is inserting the URL that I used to open the page ahead of my Initial Catalog parameter?Any assistance will be more than welcome.CJ  

View 2 Replies View Related

SQL Server 2008 :: Connection Manager Not Using Connection String Value

Feb 19, 2015

I have a child package where the ConnectionString property of a Connection Manager is set by a Parent Package Variable Configuration. I set up a script task that brings up a message box with the value of the ConnectionString property right before the dataflow task.

MessageBox.Show(Dts.Connections["CPU_*"].ConnectionString.ToString());When I run the parent package, the message box shows that the connection string is changing with every iteration, but in the dataflow it always draws the data from the same source.

The connection manager is an ADO.Net type, RetainSameConnection is set to False, and I've been researching this for days.

(Update 2/23/2015): To make this stranger, when I look at the diagnostic logs, they tell me that when the new connections are being opened they are using the new connection strings.

View 2 Replies View Related

Cannot Set Connection Property Of Backup Database Task If Connection String Is Customized In Connection Object

Aug 23, 2006

I added a connection (ADO.NET) object by name testCon in the connection manager - I wanted to programmatically supply the connection string. So I used the "Expressions" property of the connection object and set the connectionstring to one DTS variable. The idea is to supply the connection string value to the variable - so that the connection object uses my connection string.

Then I added a "Backup Database Task" to my package with the name BkpTask. Now whenever I try to set the connection property of BkpTask to the testCon connection object, by typing testCon, it automatically gets cleared. I am not able to set the connection value.

Then after spending several hours I found that this is because I have customized the connection string in testCon. If I don't customize the connection string, I am able to enter the "testCon" value in the connection property of the BkpTask.

Is this an intrinsic issue?

View 2 Replies View Related

SQL 2012 :: Catalog Doesn't Have Option To Give Read Access To SSIS Catalog To View Package Run Reports

Oct 23, 2014

"SSIS 2012 Catalog doesn't have option to give read access to SSIS Catalog to view package run reports" ... Any luck allowing power developers / operators access to READ the SQL 2012 SSIS Execution Reports without granting them SSIS_Admin or Sysadmin?

According to this link posted back in 2011 (w/ Microsoft's feedback in Nov 2011: "We’re closing this issue as “Won’t Fix.” At this point the bug does not meet our bar for resolving prior to SQL Server 2012 RTM. As we approach the SQL Server 2012 release the bar for making code changes gets progressively higher." URL....Regarding Permissions to SSIS Catalog, here are the findings. We can give access in three ways:

1. READ Access – We can provide a user db_datareader access. With this the user can see the objects within the SSIS catalog database, but cannot see the reports.

2. SSIS_ADMIN – Add the user to this database role in SSISDB. With this the user can view the reports. But it also provides them privileges to modify catalog information which is not expected. We can add it using below script EXEC sp_addrolemember 'ssis_admin' , 'REDMONDPAIntelAnalyst'

3. SYSADMIN - Add the user to this server role. This will make the user an admin on the SQL server. This is not intended. Is there any method available which will have provision to give read only access to see SSIS Catalog package execution reports and not having modify Catalog access.

View 1 Replies View Related

SQL 2012 :: SSIS Connection Initial-catalog Removed When Adding Expression To Set It Dynamically?

Feb 14, 2014

SQL 2012 SSIS package.I have a package connection that has the initialcatalog set in the connection string/properties page. This package connection also has an expression defined to set the initial catalog at runtime according to a passed in parameter. It works fine.

I am trying to create a second package in this same manner, but the connection does not seem to want to keep both the hardcoded initialcatalog and the expression to set it dynamically.

I can hardcode the initcatalog just fine, when when I add the expression to set it dynamically later, it clears out the initialcatalog I added.

What am I missing, why was I able to do this in the other package? I compared as much as I can think of between the two packages, all seems similar.

View 1 Replies View Related

Changing 'initial Catalog' On Connection Causes Analysis Services Processing Task To Fail

May 2, 2008

We find that if we deploy the OLAP database with a different name on the test server, then regardless of how we change the connection string provided to the SSIS package that processes the cube, then the package fails to connect to the database. To clarify:

In development the OLAP database is called MyOlapDB and the source database is called MySqlDB. Both are on the same machine. When the the application is built and released for test, the test team install the databases on a replica of the production environment (i.e. web app on one machine, OLAP DB on another and SQL database on yet another). They also, quite rightly, implement the new test databases so they incorporate the build version number. So, MyOlapDB123 and MySqlDB123 are both from build 123.

This is when the problems start. Regardless of how the connection string is specified in the job that processes the cube, the SSIS integration package fails with the error:

[Analysis Services Execute DDL Task] Error: Errors in the metadata manager. Either the database with the ID of 'MyOlapDB' does not exist in the server with the ID of 'OurTestServer', or the user does not have permissions to access the object.


We have tried config files and job properties, but neither work. Also, simply attempting to run the package using the DTEXECUI does not work either.

Looking inside the XML of the package, we clearly see the ConnectionManager object which has the original connection string, which is

Data Source=localhost;Initial Catalog=MyOlapDB;Provider=MSOLAP.3;Integrated Security=SSPI;Impersonation Level=Impersonate;


However, editing the initial catalog here still does not solve the problem. Searching the XML for the string MyOlapDB reveals the OLAP database name in two other places - both within the object data of the two Analysis Services Execute DDL tasks.

Anyone know how to solve this problem without having to hack the XML of the package?

View 4 Replies View Related

Connection String To Sql Server

Nov 12, 2007

 Hi I am trying to write the following connection string:public static SqlConnection connect()        {            SqlConnection sqlConn = new SqlConnection("server=9.0.3042;database=Menu;Connection Lifetime=300");            return sqlConn;        } I am trying to connect to a sql database using c# code. The code above is in a seperate file. The code below is the code used to talk to the database    SqlConnection sqlConn = connection.connect();        sqlConn.Open();                SqlCommand menubar = new SqlCommand("Select * from Menu_table", sqlConn);        SqlDataAdapter dataAdapter5 = new SqlDataAdapter();        dataAdapter5.SelectCommand = menubar;        DataSet dataSet5 = new DataSet();        dataAdapter5.Fill(dataSet5);        DataTable selcartest4 = dataSet5.Tables["table"];  However the connection is just timing out like I have the wrong address set for the connection on the first bit of code posted any heklp would be great cheers J 

View 4 Replies View Related

SQl Server Connection String

Dec 20, 2004

How do I create a connection string to connect to a Sql Server database?

I am using VB.Net to authenticate log on details.

What is the synax of the connection string?
I have tried one version but keep getting an error "Type SQLDataAdapter is not defined.

Can anyone help me with this?

View 8 Replies View Related

Need A Connection String For Sql Server Via Vb6

Jul 30, 2004

Hey guys,
sorry to bother you with something so newbish, but I am trying to connect to a remote sql server db, using vb6.
I want to use ado to do so but have been having problem with some of the samples I have found online.

I will probably just test the connection out on an existing database like pubs or northwind.

Can anyone provide me a code snip please?

This forum has always been a great resource for me, thanks again guys!

View 2 Replies View Related

Connection String For The Ms-SQl Server Using ASP.net

Jul 23, 2005

Hello,I am doing the web based project for the final year of my cousein Information Technology using Asp.net and ms-sql server.But to startwith that I need to connect my web pages to the database.So Can anyone tell me how to connect my page web to the ms-sqlserver using Asp.net(Connection String)?.It will be better if someonegive me the code for the connection string along with the explainationso that I don't have problem understanding it.Any kind of help will be appreciated.Thank You.Suchen Chodankar.

View 1 Replies View Related

Sql Server CONNECTION STRING...

Nov 7, 2005

Hi all,

View 9 Replies View Related

Connection String For Remote Sql Server

Sep 12, 2006

Hi,I trying to connect to the sql server in the network. The sqlserver is in the machine called "pinnacle". I am Using the following connection string to connect and i am getting the error "Sql server does not exist or Access denied"Public databaseConnectionStringSQL As String = "Data Source=(pinnacle);Initial Catalog=cms;Trusted_connection=True;User Id=dbuser;Password=password"Any help will be appriciated.Reagrds,Thiyasoft

View 4 Replies View Related

Sql Server 2000 Connection String

Feb 14, 2007

i'm using sql server 2005 express edition as the database server for my web application. Right now, i want to deploy it and the problem is, my hosting is using sql server 2000. So, is it possible to deploy my database that has been created in sql server 2005 in the sql server 2000? I'm afraid that the connection string for sql server 2000 is different from sql server 2005. In addition, i'm using forms authentication in my web application. So, some data regarding to the forms authentication like dbo.asp_net.membership table, dbo.asp_net.roles table is in my database. Is it the table that has been created like dbo.asp_net.membership can be used in sql server 2000 since it is created by asp.net forms authentication function? 

View 2 Replies View Related

Connection String For SQL Server Not Working

Mar 17, 2007

I have the Visual Studio 2005 Team Suite trial version and the SQL Server 2005 trial (which came with team suite) installed in my machine.
When I installed the SQL Server 2005 I installed it in the Windows Authentication mode.  So every time I open SQL Server 2005 it doesnt ask for Username/Password (Its greyed out).  The only thing available were:
Server Type: Database Engine
ServerName: ServerSue
Authentication: Windows Authentication.
Here is my Problem:
I created a small application in C#.  In the web.config file I created the following:
<appSettings>
<add key="resumecon" value="SERVER=ServerSue;database=Resume;"/>
</appSettings>
Then in the Code behind I created the following string:
string strResCon = ConfigurationManager.AppSettings["resumecon"].ToString();
Then in  method (for a Login page) I created the connection string as follows and wrote code to insert some values into the Resume database.  I called this method on a button click event.
SqlConnection conLogin = new SqlConnection(strResCon);
When I run the page and when I click the button I get the following error:
Login failed for user ''. The user is not associated with a trusted SQL Server connection.
I think some thing is wrong in the addkey of webconfig?  How do I change this?
 

View 5 Replies View Related

Problems With SQL Server Connection String

Mar 22, 2007

I am slightly confused about SQL Server connections strings.  When I used the following connection string:
string strConn = "server=deciusawa;database=xxxx;uid=xxxx;pwd=xxxx"; 
I get an error saying "Format of the initialization string does not conform to specification starting at index 13. "
I spent ages trying to figure out why this was and I eventually discovered that adding an "@" symbol before the string fixed it, i.e.
string strConn = @"server=deciusawa;database=xxxx;uid=xxxx;pwd=xxxx"; 
Most of the examples I have seen to not use the "@" symbol so I am just wondering what is does and when you need to use it?
Thanks,
Mark
 

View 2 Replies View Related

Need Help With Connection String In C# And SQL Server Express

Apr 28, 2007

 
 I am using SQL server express 2005. I can drag and drop a grid control on to my web form and choose the data source to point to a SQL server database. Then datais nicely displayed on my web form.
Now I need to manually create my connection to the database as I need to read from a text file and then populatea database table with those values I read from the text file. I have not had any success with this though and I am stuck and need some help.
Below is my C# code and I list the web.config code where my connection string is stored.
Note that I can trace into the C# line of code below. If I then do a "Quick Watch" on "myConnection" in the debugger, the followingerror message is displayed:
ServerVersion 'myConnection.ServerVersion' threw an exception of type 'System.InvalidOperationException'          string {System.InvalidOperationException}
So I don't know what the problem is here. If someone can help me out I would be forever thankfull
 
 C# code:
    SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["TheDividerConnectionString"]);
 
 Here is the connection string as defined in the web.config file:
 <connectionStrings>  <add name="TheDividerConnectionString" connectionString="Data Source=BVCOMPUTERSQLEXPRESS;Initial Catalog=TheDivider;Integrated Security=True"   providerName="System.Data.SqlClient" /> </connectionStrings>
 
 

View 3 Replies View Related

SQL Server Express Connection String

Aug 18, 2007

I'm trying really hard to set this website up so that I can have a web layer... bll, and dal. But I can't figure out the connection string in the config file. Can someone take a look? <connectionStrings>        <add name="SearchConnectionString" connectionString="Data Source=AURORASQLEXPRESS;Initial Catalog=Search;"/>        <add name="SearchEngine.DAL.Properties.Settings.SearchConnectionString" connectionString="Data Source=AURORASQLEXPRESS;Initial Catalog=Search;" providerName="System.Data.SqlClient"/></connectionStrings>

View 3 Replies View Related

Sql Server 7 Connection String Problem

Nov 11, 2005

I've been using my old connection string for years, and it has worked fine in 1.1 and 2.0 betas

It's pretty basic: "Data Source=Computername;Initial Catalog=MyDB;Integrated Security = true"

For some reason, I am having trouble getting this to work on SQL Server 7 with the release code of asp.net 2.0

What does work is to open up TCP/IP on the server network utility (I
usually only use named pipes) and change the connection string to "Data
Source=123.123.123.123;Initial Catalog=MyDB;Integrated Security = true"

The latter (with the IP of the box istead of 123....) works great, so I
can be sure that my IWAM account has correct permissions to access the
DB.

Does ASP.NET talk with sql servers using a different protocol than
Named Pipes by default? I'm a bit spooked to open up TCP/IP on my
production box as I saw the damage that SQL Slammer did a few years
back, and want to keep everything as locked down as possible.

Thanks,

John

View 3 Replies View Related

Need Help With Connection String For SQL Server 2000

Feb 4, 2006

 
I am using asp.net 2.0, and am attempting to connect to a SQL Server 2000 database. When I run the web page either in the debugger, or by viewing it in the browser, I get the following error message:
 
Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection.
 
I think that maybe my values for uid, and pwd are not correct? If this is the problem, then I don’t know what their values should be? Should uid always be equal to sa ??(If so why?)
 
Also I don’t know what the password should be. I don’t know what the name of the password as it was assigned over two years ago when I installed sql server 2000. I might need some instructions on how to find this value in SQL server.
 
Someone please help me if you can. Here is a snippet of the code I am using:
 
 
String sqlStmt = "INSERT INTO LogIn (UserName,PassWord) VALUES ('JohnyRocket','FastestRocket99')";
 
SqlConnection sqlConn = new SqlConnection("server=localhost;uid=sa;pwd=;database=MyWebSite;");
                SqlCommand sqlCmd = new SqlCommand(sqlStmt, sqlConn);
                sqlConn.Open();
 
 

View 4 Replies View Related

Connection String - Server Vs Workstation

Apr 29, 2006

I have the following connection string in my Windows app that works fine on the Server:
workstation id=SCSXP;packet size=4096;integrated security=SSPI;data source=scsxp;persist security info=False;initial catalog=nala
But when I use that string on a workstation, it times out.  I do have a Network connection to the Server. 
How should I modify the connection string to work on the workstation?
Thanks,
Bill
 

View 1 Replies View Related

Is The Connection String For SQL Server And MSDE The Same?

Jul 29, 2004

The connection string I'm currently using for SQL Server is Provider=SQLOLEDB;Server=SERVERVSDOTNET;Database= CCDDbase;Integrated Security=SSPI

would this be the same query string for MSDE database? I'm quite new in MSDE but I know that except for the tools that comes with SQL Server and its size, they are practically the same...

View 2 Replies View Related

ASP - Connection String With SQL Server Express

Feb 1, 2008

Hello,

I'm working with classic ASP and am having a terrible time trying to get a proper connection string working with my database. Could someone please advise me on how to get the following code to connect to my database (which is using Windows Authentication)?

If fileSize > 0 Then
' Connection string
Dim connStr
connStr = "Provider=SQLNCLI;Server=Dell-LaptopSQLEXPRESS;Database=Upload;Trusted_Connection=yes;"
' Recordset object
Dim rs
Set rs = Server.CreateObject("ADODB.Recordset")
rs.Open "Files", connStr, 2, 2

Right now the error I'm receiving is:
"SQL Network Interfaces: Error Locating Server/Instance Specified

Also, I'm using II7 with Vista.
Thanks,

Trix.

View 9 Replies View Related

Linked Server Connection String ??

Apr 22, 2008



What is the connection string for access a database of a linked server in sqlserver

Thanks

I add a linked server (another sqlserver server2) to my sqlserver(server1) , I need make a sqlconnection to the linked server connecting my sqlserver (server1)

View 7 Replies View Related

CustomData On SQL Server Connection String?

Apr 18, 2007

Analysis Services has a CustomData connection string property. You can put anything on it, then inside an MDX query you can use the CustomData() function to retrieve whatever was on the connection string. This is helpful for passing in a security token.



Is there anything equivalent for SQL Server?



I also posted this here, but got no response so thought I'd check in the security forum.

View 6 Replies View Related

SQL Server Connection String Problem With ASP

Jun 14, 2007

I know I am doing something boneheaded but after much Googling I still can't figure it out. I am upgrading my Windows 2000 with SQL Server 2000 machine to Windows 2003 Web with SQL Server 2005 Express.
I have a bunch of legacy ASP pages that I need to get working. But I am having a problem with my Connection String. It may stem from the fact that I did not think that before I needed a servername/instance name. I only needed an instance name on the old machine. So I've tried a bunch of different connection strings and I either get this on the ASP Pages:
Named Pipes Provider: Could not open a connection to SQL Server [53].
or this:
SQL Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF].

Here are a few connection strings I've tried (with the password etc. tweaked for the public):
ConnString = "Provider=SQLNCLI;Server=AP5;Database=abcdb;Uid=sa;Pwd=abc123;"
ConnString = "Provider=SQLNCLI;Server=AP5SQLEXPRESS;Database=abcdb;Uid=sa;Pwd=abc123!;"
ConnString = "Provider=SQLNCLI;Server=AP5AP5;Database=abcdb;Uid=sa;Pwd=abc123!;"
ConnString = "Driver={SQL Native Client};Server=AP5AP5;Database=abcdb;Uid=sa;Pwd=abc123!;"

When I go into SQL Server Management Studio at the top it says AP5AP5. I named the Windows 2003 Server the same as the SQL Server Express Instance (Both AP5), but that should be all right shouldn't it?

View 2 Replies View Related

Mirroring :: Server Connection String

Sep 8, 2015

I develop a website. When I work in local machine for login/logout, The connectionstring works well.

<add name="DefaultConnection" connectionString="Data Source=(LocalDb)v11.0;AttachDbFilename=|DataDirectory|xxxxx.mdf;Initial Catalog=Restaurants;Integrated Security=True" providerName="System.Data.SqlClient" />

But When I deploy the web to IIS server. The I always can't work normally. The system cannot find the file specified..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.ComponentModel.Win32Exception: The system cannot find the file specified

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.

[Win32Exception (0x80004005): The system cannot find the file specified].[SqlException (0x80131904): A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 52 - Unable to locate a Local Database Runtime installation. Verify that SQL Server Express is properly installed and that the Local Database Runtime feature is enabled.)]

View 5 Replies View Related

Microsoft SQL Server 2005, Connection String

Jul 27, 2006

<connectionStrings>
<add name="AppConnectionString1" connectionString="Data Source=&quot;.SQLEXPRESS&quot;;AttachDbFilename=&quot;C:Program FilesMicrosoft SQL ServerMSSQLDataAdventureWorks2000_Data.mdf&quot;;Integrated Security=True"
providerName="System.Data.SqlClient" />
</connectionStrings>
I'm running Microsoft SQL server 2005. what is the error in the above code.

View 2 Replies View Related

How To Configure Connection String For Remote Server?

Dec 5, 2006

Sorry for the newbie question, but....
I have developed a website on my local development machine. When I create the connections string VS automatically creates a path to my local hard drive inside the string.
Data Source=.SQLEXPRESS;AttachDbFilename="C:Documents and SettingsMikeMy DocumentsVisual Studio 2005WebSitesPostAlertzApp_DataPADatabase.mdf";Integrated Security=True;Connect Timeout=30;User Instance=True
However, when I deploy this website to a remote server, SQLExpress tries to attach to the file using the wrong path. How do I fix this?
Your patience is appreciated...

View 2 Replies View Related

SQL Server 2005 Enterprise Connection String.

Jan 2, 2007

Hi,
I have just uninstalled SQLEXPRESS and installed the 180 day trial SQL server 2005 enterprise edition.
I have since started to have problems with my ASP.Net Configuration Tool., can not connect to the database.
I think that the connection string in my machine.config file is incorrect, before installing I had,..:
datasource=./SQLEXPRESS,....
So i decided to change that part to the following. Would anybody know what I have put in the datasource part for the SQL server 2005 enterprise edition? At the moment I tried SQLSERVER2005 but that is incorrect,..
<add name="LocalSqlServer" connectionString="data source=./SQLSERVER2005;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true" providerName="System.Data.SqlClient" />
 

View 1 Replies View Related

SQL Server Using Windows NT Authentation Connection String

Jan 13, 2007

Database Server:

SQL Server 2005

Server = tsohaephqdb001

Database = D01DMAINTPLAN

Process Id: Windows
NT Authentation

Login = asplog

Password = 123456

 

IIS Server:  (separate machine from server)

ASP.NET Version 2.0.50727Anonymous Access = TrueUser Name = asplogPassword = 123456All other options = False 























(Generated by ASPRunner.Net)

web.config:

<?xml
version="1.0"?>

<configuration>

  <appSettings>



    <add key="LoginMethod"
value="WITHOUTLOGIN" />



    <add key="MenuFile"
value="menu.aspx" />



    <add key="StartPage"
value="menu.aspx" />

    <add key="LCID"
value="1033" />



    <add key="StringEmpty"
value="DBNull" />



  </appSettings>



  <connectionStrings>

  <add
name="Project1ConnectionString" connectionString="data
source=tsohaephqdb001;initial catalog=D01DMAINTPLAN;integrated
security=true;packet size=4096"

  
providerName="System.Data.SqlClient" />

 </connectionStrings>

  <system.web>



    <compilation debug="true"/>



    <authentication
mode="Windows"/>



  </system.web>

</configuration>



Generated Error when choosing a ASP
menu item that requires the connect string above.

Error:                                                                           


Error description: Login
failed for user ''. The user is not associated   

with
a trusted SQL Server connection

I’m
sure the SQL server and IIS server is configured correctly because I have
regular ASP running fine using DSN connect string.



I’m
new to ASP.Net and not sure about the Web.conf connect string.

View 1 Replies View Related

ASP.NET Connection String Problems With SQL Server 2000

Jul 2, 2007

My aspx page is trying to connect to a remote server with SQL Server 2000 installed on it, the ip of the server is 172.16.3.111 and the same is the instance of SQL Server, sql server is running in SQL Server Authentication mode, user id is "test" and password is "test123", name of database is myDB,the connection string which I am providing is as follows:data source=172.16.3.111172.16.3.111;user id=test;password=test123;initial catalog=myDB;"But I am getting the following exception:SQL Server does not exist or access denied.even if I try the following connection string:"data source=172.16.3.111;user id=test;password=test123;initial catalog=myDB;"than also I get the same exception
even if provide the following connection strings:
"SERVER=172.16.3.111;UID=test;PWD=test123;DATABASE =myDB;"
"SERVER=172.16.3.111172.16.3.111;UID=test;PWD=test123;DATABASE =myDB;"
 than also I get the same exceptionsCan u please tell whats the problem,is the connection string correct,the DBA has also registered me "test" as a user on the SQL server.One thing which I want to mention is that through enterprise manager I can connect and use sql server without any problems,also please note that in VS.NET when I try connecting using server explorer and test the connection than I connect successfully, than why is problem occuring in connecting throug aspx page.

View 1 Replies View Related

Connection String For Sql Server 2005 Express

Jan 10, 2008

does anyone kbnow the connection string used to connect to the database in sql server 2005 express?
can someone one give me sample codes for it? thanks.


thanks

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved