473,320 Members | 2,202 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,320 software developers and data experts.

SQL Express 2005 won't let me in

Hi. I'm trying to use SQLExpress 2005 (default install vsnet 2005). No
matter what I tried, I still can't use it.

A. In SQL server configuration manager I have tried the following:
1. Logon as built-in account - network service. Then in VSNET, new
database reference, I have servername="\SQLEXPRESS", Use windows
authentication, and I enter dbname=master. I get an error saying that
"... under the default settings, sql server does not allow remote
connections (provider SQL Network Interfaces, error 25: connection
string is not valid".
2. I set logon as built-in account - local service and I restart BOTH
SQL server and SQL browser.
The exact same thing happens for logon as built-in account - local
service.
3. I set logon as built-in account - local system and I try to restart
BOTH SQL server and SQL browser. SQL server restarts. SQL browser
crashes. My CPU usage goes sky-high and the only way out is the task
manager.
I only have ONE computer, so it should run as local system, right ?
I also read somewhere that "named pipes" should be enabled. I did that
in SQL server 2005 network configuration - no improvement.
B. I also tried loging-in with a user name and password. Therefore, in
SQL server configuration manager I have set AccountName as
"MyMachineName\Administrator" where, of course, my machine name is the
actual name of the machine. I have set no password on this machine, so
I leave the password blank and I click Apply. I get a "WMI provider
error: Invalid Parameter [0x80041008]". Very helpful indeed ! So I
assume that I need a pass, but which one ? I have tried "sa" and this
time I got "WMI provider error: The specified network password is not
correct [0x80070056]".
C. I have also tried to connect thru ODBC data source administrator...
no go.
So, please, what should I do to make this #(*&$(*#@&$ work ???
Thank you very much.

Apr 5 '06 #1
3 7000
SQL Express by default has remote connections disabled. Here is what you do:
open the SQL Server 2005 Surface Area Configuration tool (this is in the
configuration tools program group sub menu in the SQL Server program group
from Start->Programs). Click on "Surface Area Configuration for Services and
Connections", choose your instance of SQLEXPRESS, click on Remote Connections
and choose Local and remote connections.

Hope this helps.
Apr 5 '06 #2
Thank you... but I tried that yesterday, with the results as in my previous
post :-(

"Krosslern" <Kr*******@discussions.microsoft.com> wrote in message
news:F8**********************************@microsof t.com...
SQL Express by default has remote connections disabled. Here is what you
do:
open the SQL Server 2005 Surface Area Configuration tool (this is in the
configuration tools program group sub menu in the SQL Server program group
from Start->Programs). Click on "Surface Area Configuration for Services
and
Connections", choose your instance of SQLEXPRESS, click on Remote
Connections
and choose Local and remote connections.

Hope this helps.

Apr 5 '06 #3
Hi,
I have servername="\SQLEXPRESS"


Try "localhost\SQLEXPRESS" or "127.0.0.1\SQLEXPRESS"
If this does not work, go to "Start -> Programs -> Sql Server 2005 ->
Configuration Tools -> Sql Server Surface Area Configuration" then click
surface area for features.
Browse to your database engine and remote connections and allow TCP/IP
from remote connections.

maybe this helps
Markus
Apr 6 '06 #4

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

Similar topics

7
by: ad | last post by:
I found that there is reporting service bundle with SQLSever 2005 express. Can VS2005 express can use the reporting service in SQLSever 2005 express?
2
by: vbmark | last post by:
I get the following message box: Visual Basic 2005 Express Edition Beta 2- ENU Setup =================================================== Setup has detected that previous versions of the...
9
by: Al_C | last post by:
What is the future of VB express? We're doing an app in VB2003 and like some of the VB controls in VS2005. Is VB Express a serious product? Let's face it, the price makes me wonder? Free is never...
8
by: olrt | last post by:
Hello, I plan to install Visual C# 2005 Express. I need a source code control system. It seems that there's no express version of Visual Source Safe. What should I do ? Is Visual C# 2005 Express...
2
by: kress1963nov22 | last post by:
I recently purchased a good MS book ("Build a Web Site Now") by Jim Buyens. It has the Express Edition of MS-Visual Web Developer 2005 on CD and also MS SQL Server 2005 Express Edition on the CD. A...
25
by: Marco | last post by:
Hi everyone. I've been trying to move some small applications written in vb.net 2003 to vb.net 2005 express just for testing purposes. I have noticed so far that the applications seem to run ...
9
by: Gabriel | last post by:
Hello, I installed SQL server 2005 SP1 on a Windows XP SP2 From Visual Studio, I'm trygin to create a connection to a database, but I receive this error but I'm creating the connection (I...
12
by: Light | last post by:
Hi all, I posted this question in the sqlserver.newusers group but I am not getting any response there so I am going to try it on the fine folks here:). I inherited some legacy ASP codes in my...
3
by: =?Utf-8?B?TUVH?= | last post by:
I've installed VB Express 2005 and SQL Server 2005 Express on a workstation that had SQL 2000 on it. I can only get VB Express to connect to the SQL Server 2005. From other groups I read that...
10
by: kimiraikkonen | last post by:
Visual C#.NET 2005 express has some issues, unlike VB.NET 2005 has none of them: The most annoying one is: For example if there's a coding error, it must be reported at the buttom of the screen...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

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.