All Questions
Tagged with connection-string sql-server-2008
136
questions
120
votes
16
answers
470k
views
How to find SQL Server running port?
Yes I read this How to find the port for MS SQL Server 2008?
no luck.
telnet 1433
returns connection failed, so I must specify other port.
I tried to use
netstat -abn
but I don't see ...
- 2,381
89
votes
3
answers
272k
views
Should I set max pool size in database connection string? What happens if I don't?
This is my database connection string. I did not set max pool size until now.
public static string srConnectionString =
"server=localhost;database=mydb;uid=sa;pwd=mypw;";
So ...
- 23.6k
54
votes
1
answer
260k
views
A network-related or instance-specific error occurred while establishing a connection to SQL Server [closed]
I deployed my asp.net web application on somee.com, whenever I login into this site (ipc.somee.com) it gives me a network related error like:
A network-related or instance-specific error occurred ...
- 609
46
votes
1
answer
42k
views
SQL Server Connection Strings - dot(".") or "(local)" or "(localdb)"
I've recently had to install SQL Server and restore a database to 2 laptops, the first took me a couple of days to figure out, the second I'm still struggling on.
On both I was getting this error ...
- 4,369
37
votes
9
answers
140k
views
Login failed for user 'NT AUTHORITY\NETWORK SERVICE'
I been strugling with this for 2 days now without comming any closer to solution. I have read 20-30 threads alteast and stil can not resolve this.
Please help me out.
I have disable anonymous ...
- 19k
34
votes
9
answers
63k
views
Keyword not supported: 'server'
I've been trying to edit my connection string for uploading my website to a server.
I am not really experienced with this. I got this exception: the Keyword not supported: 'server'.
Here is my ...
- 729
18
votes
11
answers
26k
views
SQL Server "." Alias Not Working
I've added an alias of "." which should point to my local (named) instance, ".\SQL2008". But when I try to connect to ".", it times out.
Am I missing something or is this not allowed?
Aliases I've ...
- 27.3k
16
votes
4
answers
62k
views
SSRS report subscriptions cannot be created
I am not able to create subscriptions for SSRS reports as it gives the following error:
Subscriptions cannot be created because the credentials used to run
the report are not stored, or if a ...
- 541
15
votes
1
answer
21k
views
Force the TCP/IP protocol in connection string
I have a database driven website written in asp.net. I'd like to modify the connection string to force protocol TCP. Please advise.
<add name="TESTConnectionString"
connectionString=...
- 791
12
votes
3
answers
16k
views
How do we alias a Sql Server instance name used in a Connection String .config?
I have two development teams, that come from different groups.
Group A develops against a local default instance of Sql Server 2008 R2;
Group B develops against a local named instance of Sql ...
- 20.9k
12
votes
2
answers
91k
views
SQL Server Error "Named Pipes Provider: Could not open a connection to SQL Server [53]"
I used to have a desktop application pointing to a Sybase database through an .ini file that had this connection string:
CONNECTION_NAME = "DSN="Dna_Name";UID="User";PWD="Password""
It worked ...
- 1,317
10
votes
4
answers
52k
views
Classic ASP - SQL Server 2008 Connection String using Windows Authentication
This should be painfully simple, but I cannot come up with a working connection string for a local copy of SQL Server 2008 using Windows Authentication. I've tried using the Data Link Properties tool ...
- 24.6k
9
votes
3
answers
68k
views
Cannot connect to database using localhost\sqlserver
I know we should be aware of such phrases but all of a sudden all my connections to localhost\sqlexpress stopped working. As .\sqlexpress and (local)\sqlexpress work, this wouldn't be a big deal if ...
- 155
7
votes
2
answers
7k
views
How can I create valid connection string by using shared memory protocol to connect a named instance of sql server?
How can I create a valid connection string by using shared memory protocol to connect a named instance of sql server while the sql server browser is disabled?
- 6,499
7
votes
3
answers
11k
views
Sql connection waits 15 seconds despite 3 seconds timeout in connection string
I have a website using Microsoft SQL 2008 server over local network. Sometimes, SQL server machine is rebooted, and so the website fails to connect to the database. If the machine is up and running, ...
- 51.7k
4
votes
1
answer
39k
views
Connection string for a remote SQL server
I am trying to connect to a remote SQL server. I would like to know the proper way to connect to the server. TCP/IP protocol is enabled. I am trying this way:
@"Server=myserver.com\SQLEXPRESS; ...
- 8,175
3
votes
4
answers
314
views
SQL Server 2008 and Connection String
I have created a login in SQL Server 2008 with username= smart_provider and password = password.
Now, I added the following connection string to my project:
<add name="DB_Connection"
...
- 4,537
3
votes
4
answers
992
views
In MSSQL (TSQL), Can I specify a contextual variable that lives in a connection string, but does not affect pooling?
To explain the need further, consider this scenario:
In a legacy system that relies heavily on TRIGGERS, we need to provide a token of some sort (let's call it "SessionID") to be inserted into some ...
- 31.7k
3
votes
2
answers
4k
views
Does the Entity Framework use a default intital catalog and what assumptions does it make?
I did (pretty much) everything correct in a new EF project, but I forgot to use the named connection string in the EF context class, so, it used the default.
It created a new database inside the SQL ...
- 10.5k
3
votes
2
answers
43k
views
"The ConnectionString property has not been initialized" error in VB.NET
Every time I tried to connect to the database it give me this error "The ConnectionString property has not been initialized"
what can I do to solve this?
here are my codes
Module Module1
...
- 125
3
votes
1
answer
401
views
Why Doesn't The EntityConnection Object Contain the Login Password?
I've got an app that uses EF CTP5.
In this particular situation, i need to degrade to some classic ADO.NET (in order to read multiple result sets in a stored procedure, which EF does not support).
...
- 72.8k
3
votes
2
answers
90
views
Please help me with database connection types in Windows
Sorry for a badly-phrased question. I have a requirement coming from a non-technical person that I need to make sense of. I am basically told: "Here use 'Driver={SQL Server};Server=SERVERNAME\...
3
votes
1
answer
82k
views
vb6 ADODB connection string to sql server 2008
I recently migrated a database from sql server 2005 to 2008 on windows server 2008. Clients connect fine from their XP machines and so does the SQL Management Studio 2008. I have also tested a ...
- 13.7k
3
votes
2
answers
5k
views
Connecting to SQL server via TCP/IP, not NP
As I found out, my SQL server has disabled Named Pipes, but enabled TCP/IP (and it will stay this way). Now I am trying to connect from the visual studio to the database, but with no luck.
I've tried ...
- 811
3
votes
1
answer
4k
views
getting the connection string for MS SQL Server 2008
I am new to SQL and not too sure how to connect R to an SQL database.
I would like to use R to connect to the database, but am unsure what the string is to be able to do this.
The database is not ...
user1963962
3
votes
1
answer
11k
views
Data Source setting in Connection String
Consider these two connection strings that are different only by their Data Source settings:
Data Source=OEM-PC\SQLEXPRESS;Initial Catalog=<databasename>;
Integrated Security=False;Persist ...
3
votes
1
answer
5k
views
VARCHAR size limit in Excel spreadsheets
I'm trying to read some data from an SQL Server 2008 database into an Excel 2007 spreadsheet with C#, using this connection string:
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=foo.xlsx;Extended ...
- 4,620
3
votes
2
answers
4k
views
sql server 2008 connection string error
I know this is a quite standard issue... but can't figure it out..
So here's what i want to do:
I want to connect to my local sql server .\SQLEXPRESS by windows authentication. I can login by using ...
- 4,142
3
votes
1
answer
12k
views
How can i connect to sql server from my android application?
I'm developing an android application. I need connect to sql server. I wrote a code for test connection but i get this error :
java.sql.SQLException: Network error IOException: Permission denied
...
- 51
3
votes
2
answers
5k
views
Executereader and execute non-query in a single connection in ado.net
The below snippet employs multiple queries inside the same connection string. first i'm selecting the some datas from the DB then before closing the datareader(dr) i would like to do some validations ...
- 246
2
votes
7
answers
26k
views
How to check is connection string valid?
I have to save data and I have to test connection before to save it. How can I test that this connection string is valid for a particular connection?
My code is like this:
static public bool ...
- 3,062
2
votes
3
answers
12k
views
sql server 2008 Login failed for user 'NT AUTHORITY\NETWORK SERVICE'
I am trying to connect my website to my sql server 2008 r2 on windows server 2003 with .net framework 4
This is the connection string:
<add name="TestDbConnectionString"
connectionString="...
- 415
2
votes
3
answers
36k
views
How to connect to Sql Server 2008 database from Visual Basic 6?
What is the correct connection string and what are the requirements for connecting to Sql Server 2008 database from Visual Basic 6?
- 325
2
votes
2
answers
11k
views
SQL Server connection string question [closed]
I'm trying to connect to a named SQL instance on the server.
There is already default instance of SQL Server 2005 and a newly named one - SQL Server 2008. I'm using the "Network library" property to ...
- 3,853
2
votes
1
answer
7k
views
Is SQL Server's Remote Login Timeout setting equivalent to setting Connection Timeout value in connection string?
In SQL Server Advanced properties there is Remote Login Timeout setting within the Network section which defaults to 20 seconds.
http://technet.microsoft.com/en-us/library/ms175136.aspx
Is this ...
- 12.1k
2
votes
2
answers
10k
views
Connecting to SQL server from another computer
I am using c# to connect to sql server on another computer on the network but i got an exception message Login failed for user ' username' however the server log state that the connection is ...
- 1,697
2
votes
2
answers
3k
views
SSAS 2008 R2 - Datasource with an DNS Alias not working
I have an SQL Server with SQL Server Engine and SQL Server Analysis Services (2008 R2). The physical name of the server is SQ21. For beeing flexible we created a dns alias (Host A) which points to ...
- 171
2
votes
1
answer
9k
views
Classic ASP Remote SQL Connection String
I have a dilemma which is completely and utterly baffling me...
We have a Classic ASP site which has been running for about a year, its powered via a local Win2008 SQL database (The SQL Express ...
- 9,437
2
votes
1
answer
3k
views
Access 2010 linked to SQL Server 2008 tables - unable to change tabledef.connection to SQL Server Authentication DSN-Less
I usually link SQL Server 2008 tables in Access 2010 via DSN for development, then make it DSN-Less via VBA code (see below).
I've now decided to make the connection SQl Server authentication, ...
- 3,118
2
votes
1
answer
8k
views
Login failed for user 'someone'
I work on Microsoft SQL Server 2008 R1 and visual studio 2010.
My target is to clone a server to a new machine. However, after setting the application up and entering "local/storytelling" in the ...
- 2,117
2
votes
3
answers
29k
views
Connection string to connect sql server 2008 which is in another server
I use the below connection string to connect to a sqlserver 2008 located in another server.
How to i connect to it from ASP using vbscript?
application("database_connectionstring_internal") = "DRIVER=...
- 8,302
2
votes
1
answer
1k
views
Net_Transport TPC and Session with MARS Enabled
I'm working on a site with several apps and services with EF and the database is throwing the following error:
The server will drop the connection, because the client driver has sent multiple
...
- 255
1
vote
4
answers
18k
views
VB.NET connection string for client-server application
Case :
I'm creating a desktop application with VB.NET (Windows Forms), and using SQL Server 2008 Express for its database.
Problem :
I want to create a client-server application, it means I just ...
- 443
1
vote
1
answer
12k
views
ConnectionString issues - SQL Server 2008 on Windows 2008
We have a third party program that used to run on Windows 2003 against SQL Server 2000 database (app and db are on same machine). We are trying to migrate/install it on Windows 2008/ SQL Server 2008.
...
- 2,259
1
vote
3
answers
2k
views
cannot connect sql server 2008 from another computer [duplicate]
Possible Duplicate:
System.Data.SqlClient.SqlException A network-related or instance-specific error
i have winform application in c# which connect to my own db and its working fine my current sql ...
- 181
1
vote
2
answers
5k
views
C# and SQL Server 2008 R2: Finding DB Address and connection string
I have SQL Server 2008 R2 installed and have the necessary databases created. Now I am trying to connect to the server through C# and failing miserably. I have tried several connection string formats ...
- 657
1
vote
1
answer
471
views
Unable to connect to SQL Server remotely
I have a fully funtional WPF application running on my local machine with SQL Server 2008 as database. SQL Server Management studio is also setup on my machine. Now I want my application to be ...
- 2,596
1
vote
1
answer
2k
views
Strange Thing: getting error if using SQLOLEDB instead of ODBC in connection string
BACKGROUND:
Our Classic ASP & SQL Server based application was working perfectly with ODBC connection string.
However, after a recent windows update, application went DOWN, application was ...
- 334
1
vote
2
answers
5k
views
Connect ColdFusion to SQL Server database instance
I am trying to connect to a SQL server (2008) database instance in ColdFusion 9 but there is no where to put an instance name in the CF administrator. I can get in with .net using a connection string ...
- 15.4k
1
vote
1
answer
3k
views
IP versus localhost for SQL Server connection string
Say I have SQL Server installed on a server with an IP of 10.1.2.3. If I have a process running on that server that wishes to connect to the db it can use either:
10.1.2.3,1433
localhost,1433
...
- 2,093