Re: Cannot connect to SQL express database ????

OK it works now rick...
I have made 2 mistakes...
Frist of all I forgot to open the port 1500 in my windows firewall.
Then I was accessing my server by using <myPCname>\SQLEXPRESS as I use to do
normally with SQL server.

SO in order to work I have to connect using tcp:<myPCname>\SQLEXPRESS,1500

But I like whem I undersatnd things. This connection string using sytax
above is use like that only for this express edition ? I guess not, I mean I
have made many connection like that with SQL server ( On a real server sure)
and I was juist using the instance and Pc name.

Or may be it would work also if I add left the default setting when you use
TCP as port 1443 and let SQL as dynamic mode and then just open the port 1443
on my firewall. Then use as connection string :<myPCname>\SQLEXPRESS.

But of course dynamic means dynamic.
Does it means that this dynamic TP port seting should never be use with SQL
server ?

regards
serge

"Rick Byham, (MSFT)" wrote:

Did you stop and restart SQL Server 2005 Express Edition after setting 1500
as the fixed port?
Are you attempting to connect to the Express Edition by name in the format
computer_name\SQLExpress ?
Is the SQL Server Browser service running?
Can you connect to the Express Edition by the port number using
computer_name,1500 or by IP address in the format 127.025.144.315,1500 ?
--
Rick Byham (MSFT)
This posting is provided "AS IS" with no warranties, and confers no rights.

"calderara" <calderara@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:F1AB79D1-899E-40C6-BE14-21D0305C36CA@xxxxxxxxxxxxxxxx
Thnaks for your reply...
I have check seetings as describe in this link.

What happen is that I have SQL express install on a Vista machine
Then I set use of tcp port from the surface configuration tool and set
port
to 1500
From a simple remote machine running w2000, I try to establish an ODBC
connection to my VIsta machine where SQL express is installed.
For that I have install on my 2000 machine the SQL native client for 2005
and try to define a DSN name but when trying to connect...no way...

Any ideas ?

regards
serge
"Rick Byham, (MSFT)" wrote:

Probably either the SQL Server Express instance has not enabled remote
connections, or a firewall is blocking the connection.
Run through the short tutorial in Books Online and see if that solves the
problem. The tutorial is also online at
http://msdn2.microsoft.com/en-us/library/ms345318.aspx Note that lesson 2
is
Connecting from Another Computer.
--
Rick Byham (MSFT)
This posting is provided "AS IS" with no warranties, and confers no
rights.

"calderara" <calderara@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:067F10D8-72B1-4858-AE9F-E5EEF213BEF1@xxxxxxxxxxxxxxxx
Dear all,

I have setup a database under SQLexpress 2005 which is install on a
Vista
OS.
I can manage without any problem my database from the VIsta
workstation.

Then on an other PC, I am trying to create a connection to that databse
with
.NET 1.1, but no luck

I ma using similar conenction string as for an SQL server databse
excpet
that Server="MyWorkStationName\SQLEXPRESS".

I have place the conenctionstring in a config file as follow :


"Database=Line_Config;Server=MyWorkStationName\SQLEXPRESS;uid=rptuser;Pwd=reporting"

What is wrong that prebvent me from connection to database ?

Is it possible to connect to an SQLExpress database located on an other
PC
?

thnaks for help
regards
serge


.

Relevant Pages

  • Re: provider: Named Pipes Provider, error: 40 - Could not open a c
    ... I have tried connecting to Sql Management Studio and it worked pretty much ... An error has occurred while establishing a connection to the server. ... under the default settings SQL Server does not allow remote connections. ... I have a sql server install / database on the web server. ...
    (microsoft.public.sqlserver.connect)
  • Re: Merge replication in SQL Server
    ... However, port 443 is for https, did you want your SQL ... Configuring an instance of SQL Server to use a static port ... you can script out replication jobs by right clicking on a publication ...
    (microsoft.public.sqlserver.replication)
  • RE: Logging in in background
    ... wold take all kinds of modifictions as I'd need to be checking that each SQL ... my database and all have connection strings associated with them. ... I suspect that there is also an issue on the SQL Server side as I keep ...
    (microsoft.public.access.modulesdaovba)
  • Re: advice about a worm intrusion alert
    ... Port 1434 is the SQL Browser service used for locating SQL Servers. ... connectivity - and I had no internet access on the wireless XP machine. ... Still no connection. ...
    (microsoft.public.sqlserver.security)
  • .Net framework error
    ... Unfortunately the information is very limited and usually the report just ... The application is a front end for a SQL Server 2005 Express database, ... connection string in the app config file. ...
    (microsoft.public.dotnet.languages.vb)