473,408 Members | 2,477 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,408 software developers and data experts.

Cannot connect to SQLEXPRESS via MS Enterprise Library??


Windows XP
MS SQLExpress
VS 2003
..NET 1.x SP1 {for Application}
..NET 2.0 {for SQLExpress}
MS Enterprise Library June 2005

This works from a command prompt

osql -E -S localhost\SQLEXPRESS
use <MyDatabase>
select * from <MyTable>
go


However on the same machine, attempting to use this
dataconfiguration.xml entry throws "SQL Server does not exist or access
is denied":

<connectionString name="SqlServerLocalHost">
<parameters>
<parameter name="database" value="<MyDatabase>"
isSensitive="false" />
<parameter name="Integrated Security" value="True"
isSensitive="false" />
<parameter name="server" value="localhost\SQLEXPRESS"
isSensitive="false" />
</parameters>
</connectionString>

Any ideas? Thanx in advance for your help...

Mar 20 '06 #1
2 1855

Nevermind I fixed it...

Needed to start the SQL Browser service...

Mar 21 '06 #2
Don't know if Express comes with "SQL Server Configuration Manager" utility
though, but if it does you can change the TCP/IP properties and turn off
dynamic port mappings and enable the default TCP/IP port 1433 (or another
free port). When done, you can stop the Browser Service and connect your
clients over TCP/IP.

Willy.

"Crash" <so*********@san.rr.com> wrote in message
news:11*********************@j33g2000cwa.googlegro ups.com...
|
| Nevermind I fixed it...
|
| Needed to start the SQL Browser service...
|
Mar 21 '06 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Jay Chan | last post by:
We have just installed a SQL Server 2000 (SP 3A) onto a computer that has Windows-2003 Server on it. Now, we cannot get access to that database server from other computers. Seem like this may be an...
0
by: Zorba.GR | last post by:
IBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit, 64 bit) (MULTiOS, Windows, Linux, Solaris), IBM iSoft Commerce Suite Server Enterprise v3.2.01, IBM Tivoli Storage Resource Manager...
2
by: K B | last post by:
Hi, I've just started using Visual Studio 2005 but I do NOT want to use SqlExpress but my existing sql server database. I've searched and did the following: ran the aspnet_regsql.exe to update...
7
by: wally | last post by:
I have Visual Studio 2005 Pro. I installed SQL Express 2005 and rebooted. But, when I right click on "Data Connections" in the Server Explorer and choose "Create New SQL Server Database..." and...
6
by: antonyliu2002 | last post by:
I was able to view table content easily before, but after I reinstalled everything, I cannot find the option to view table content in MS SQL Server Express. I can define table with no problem. ...
4
by: shapper | last post by:
Hello, I am using Microsoft Enterprise Library, on a class, to connect to a database as follows: Dim db As Database = DatabaseFactory.CreateDatabase("DatabaseName") However, I would like...
1
by: rubeel | last post by:
I cannot seem to connect to this Instance locally which was i able to in the past. I can connect to the instance from out side. The instance is running and the DBs in the instance are available and...
1
by: Swagener | last post by:
The aim is to get it working on this machine so I can port everything to a Enterprise Version but can't get around this error for the last two days. Any help is much appreciated, as I am not...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.