Having trouble installing SQL Server 2005 SP1

I'm Having problem installing SQL server 2005 SP1 on Windows 2003 server R2 SP2.

The log file talk about SQL server express but I have SQL server 2005.

03/19/2007 13:49:07.203 ================================================================================
03/19/2007 13:49:07.203 Hotfix package launched
03/19/2007 13:49:32.984 Attempting to install instance: SQL Server Native Client
03/19/2007 13:49:33.000 Attempting to install target: OMNIWEBPACS
03/19/2007 13:49:33.000 Attempting to install file: sqlncli.msi
03/19/2007 13:49:33.015 Attempting to install file: \\OMNIWEBPACS\d$\bc06cd32e1991973c97744b9c4\HotFixSqlncli\Files\sqlncli.msi
03/19/2007 13:49:33.015 Creating MSI install log file at: C:\WINDOWS\Hotfix\Redist9\Logs\Redist9_Hotfix_KB913090_sqlncli.msi.log
03/19/2007 13:49:33.015 Successfully opened registry key: Software\Policies\Microsoft\Windows\Installer
03/19/2007 13:49:33.015 Failed to read registry key: Debug
03/19/2007 13:49:34.062 MSP returned 0: The action completed successfully.
03/19/2007 13:49:34.062 Successfully opened registry key: Software\Policies\Microsoft\Windows\Installer
03/19/2007 13:49:34.062 Failed to read registry key: Debug
03/19/2007 13:49:34.062 Successfully installed file: \\OMNIWEBPACS\d$\bc06cd32e1991973c97744b9c4\HotFixSqlncli\Files\sqlncli.msi
03/19/2007 13:49:34.062 Successfully installed target: OMNIWEBPACS
03/19/2007 13:49:34.062 Successfully installed instance: SQL Server Native Client
03/19/2007 13:49:34.062
03/19/2007 13:49:34.062 Product Status Summary:
03/19/2007 13:49:34.062 Product: SQL Server Native Client
03/19/2007 13:49:34.062 SQL Server Native Client (RTM ) - Success
03/19/2007 13:49:34.062
03/19/2007 13:49:34.062 Product: Setup Support Files
03/19/2007 13:49:34.062 Setup Support Files (RTM ) - Not Applied
03/19/2007 13:49:34.062
03/19/2007 13:49:34.062 Product: Database Services
03/19/2007 13:49:34.062 Database Services (SP1 2047 ENU) - NA
03/19/2007 13:49:34.062 Details: Instances of SQL Server Express cannot be updated by using this Service Pack installer. To update instances of SQL Server Express, use the SQL Server Express Service Pack installer.
03/19/2007 13:49:34.062
03/19/2007 13:49:34.062 Product: Database Services
03/19/2007 13:49:34.062 Database Services (RTM 1399 ENU) - Not Applied
03/19/2007 13:49:34.062
03/19/2007 13:49:34.062 Product: Integration Services
03/19/2007 13:49:34.062 Integration Services (RTM 1399 ENU) - Not Applied
03/19/2007 13:49:34.062
03/19/2007 13:49:34.062 Product: Client Components
03/19/2007 13:49:34.062 Client Components (RTM 1399 ENU) - Not Applied
03/19/2007 13:49:34.062
03/19/2007 13:49:34.062 Product: MSXML 6.0 Parser
03/19/2007 13:49:34.062 MSXML 6.0 Parser (RTM ) - Not Applied
03/19/2007 13:49:34.062
03/19/2007 13:49:34.062 Product: SQLXML4
03/19/2007 13:49:34.062 SQLXML4 (RTM ) - Not Applied
03/19/2007 13:49:34.062
03/19/2007 13:49:34.062 Product: Backward Compatibility
03/19/2007 13:49:34.078 Backward Compatibility (RTM ) - Not Applied
03/19/2007 13:49:34.078
03/19/2007 13:49:34.078 Product: Microsoft SQL Server VSS Writer
03/19/2007 13:49:34.078 Microsoft SQL Server VSS Writer (RTM ) - Not Applied
03/19/2007 13:49:34.078

any Idea?

It means that you take the wrong package to apply. You will need to get the following packages for ENU depending on the processor archiectures.

SQLServer2005SP1-KB913090-x86-ENU.exe

SQLServer2005SP1-KB913090-x64-ENU.exe

SQLServer2005SP1-KB913090-ia64-ENU.exe

Having trouble deploying a report

I've installed SQL Server 2005 express SP2 with SQL Server Reporting
Services, along with the Business Intelligence Development Studio from
the SQL Server Express Toolkit SP2. I've created a reports project
and a simple report that I'm trying to deploy. When I try to deploy,
I get prompted for a username and password. I've tried all the
username and password for this computer combinations I can think of,
but it doesn't recognize any of them. I have the virtual directory for
the SQL Reports set to 'integrated windows'. Any ideas about what I'm
missing?
-MichaelOn Jan 19, 7:07 pm, michael.sle...@.gmail.com wrote:
> I've installed SQL Server 2005 express SP2 with SQL Server Reporting
> Services, along with the Business Intelligence Development Studio from
> the SQL Server Express Toolkit SP2. I've created a reports project
> and a simple report that I'm trying to deploy. When I try to deploy,
> I get prompted for a username and password. I've tried all the
> username and password for this computer combinations I can think of,
> but it doesn't recognize any of them. I have the virtual directory for
> the SQL Reports set to 'integrated windows'. Any ideas about what I'm
> missing?
> -Michael
Have you created at least one user account in the Report Manager? If
you haven't, you will want to create a user account with at least
Browser privileges in the Report Manager, preferably set to your
current windows domain account (i.e., DOMAIN_NAME\UserName). Also, if
you are using Firefox or some other non-IE browser, the authentication
window always pops up. If this doesn't help, you may need to evaluate
the security on the Reports and ReportServer virtual directories in
IIS. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||Why not uploading the report using report manager?
http://localhost/reportS
Then "Upload Report"
See if you get an error message there, possibly more specific and post this
here.
Regards
Ralf Stofer
"EMartinez" wrote:
> On Jan 19, 7:07 pm, michael.sle...@.gmail.com wrote:
> > I've installed SQL Server 2005 express SP2 with SQL Server Reporting
> > Services, along with the Business Intelligence Development Studio from
> > the SQL Server Express Toolkit SP2. I've created a reports project
> > and a simple report that I'm trying to deploy. When I try to deploy,
> > I get prompted for a username and password. I've tried all the
> > username and password for this computer combinations I can think of,
> > but it doesn't recognize any of them. I have the virtual directory for
> > the SQL Reports set to 'integrated windows'. Any ideas about what I'm
> > missing?
> >
> > -Michael
>
> Have you created at least one user account in the Report Manager? If
> you haven't, you will want to create a user account with at least
> Browser privileges in the Report Manager, preferably set to your
> current windows domain account (i.e., DOMAIN_NAME\UserName). Also, if
> you are using Firefox or some other non-IE browser, the authentication
> window always pops up. If this doesn't help, you may need to evaluate
> the security on the Reports and ReportServer virtual directories in
> IIS. Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||On Jan 21, 2:35 pm, Ralf Stofer <RalfSto...@.discussions.microsoft.com>
wrote:
> Why not uploading the report using report manager?http://localhost/reportS
> Then "Upload Report"
> See if you get an error message there, possibly more specific and post this
> here.
> Regards
> Ralf Stofer
> "EMartinez" wrote:
> > On Jan 19, 7:07 pm, michael.sle...@.gmail.com wrote:
> > > I've installed SQL Server 2005 express SP2 with SQL Server Reporting
> > > Services, along with the Business Intelligence Development Studio from
> > > the SQL Server Express Toolkit SP2. I've created a reports project
> > > and a simple report that I'm trying to deploy. When I try to deploy,
> > > I get prompted for a username and password. I've tried all the
> > > username and password for this computer combinations I can think of,
> > > but it doesn't recognize any of them. I have the virtual directory for
> > > the SQL Reports set to 'integrated windows'. Any ideas about what I'm
> > > missing?
> > > -Michael
> > Have you created at least one user account in the Report Manager? If
> > you haven't, you will want to create a user account with at least
> > Browser privileges in the Report Manager, preferably set to your
> > current windows domain account (i.e., DOMAIN_NAME\UserName). Also, if
> > you are using Firefox or some other non-IE browser, the authentication
> > window always pops up. If this doesn't help, you may need to evaluate
> > the security on the Reports and ReportServer virtual directories in
> > IIS. Hope this helps.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
In order to upload a report via the Report Manager, the items I
mentioned above need to be in place beforehand.
Regards,
Enrique Martinez
Sr. Software Consultant

Having SQL Profiler while SQL Express Installed

Dear All,
Is it possible for me to have a SQL profiler install in my local while i hav
e running SQL Express in my machine?
Please advise, thank you.If you have a copy of sql server and want to install the management tools yo
u can install them on a machine regardless of the edition of sql server actu
ally running on the machine. However, I haven't tried running Profiler again
st SQL Express, but I don't see why you can't. But you'll have to actually t
ry that yourself.
Mark
"Connie" <yfchan@.kdu.edu.my> wrote in message news:%23LrYcIUtGHA.1888@.TK2MSF
TNGP03.phx.gbl...
Dear All,
Is it possible for me to have a SQL profiler install in my local while i hav
e running SQL Express in my machine?
Please advise, thank you.

Having SQL Profiler while SQL Express Installed

This is a multi-part message in MIME format.
--=_NextPart_000_0008_01C6B584.FD651AD0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Dear All,
Is it possible for me to have a SQL profiler install in my local while i = have running SQL Express in my machine?
Please advise, thank you.
--=_NextPart_000_0008_01C6B584.FD651AD0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Dear All,

Is it possible for me to have a SQL profiler install in my local = while i have running SQL Express in my machine?

Please advise, thank you.
--=_NextPart_000_0008_01C6B584.FD651AD0--This is a multi-part message in MIME format.
--=_NextPart_000_0034_01C6B540.6D9D7D50
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
If you have a copy of sql server and want to install the management =tools you can install them on a machine regardless of the edition of sql =server actually running on the machine. However, I haven't tried running =Profiler against SQL Express, but I don't see why you can't. But you'll =have to actually try that yourself.
Mark
"Connie" <yfchan@.kdu.edu.my> wrote in message =news:%23LrYcIUtGHA.1888@.TK2MSFTNGP03.phx.gbl...
Dear All,
Is it possible for me to have a SQL profiler install in my local while =i have running SQL Express in my machine?
Please advise, thank you.
--=_NextPart_000_0034_01C6B540.6D9D7D50
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&

---

If you have a copy of sql server and =want to install the management tools you can install them on a machine =regardless of the edition of sql server actually running on the machine. However, I =haven't tried running Profiler against SQL Express, but I don't see why you can't. But =you'll have to actually try that yourself.
Mark
"Connie" wrote in message news:%23LrYcIUtGHA.=1888@.TK2MSFTNGP03.phx.gbl...
Dear All,

Is it possible for me to have a SQL profiler install in my =local while i have running SQL Express in my machine?

Please advise, thank you.

---

--=_NextPart_000_0034_01C6B540.6D9D7D50--sql

Having some trouble connecting to a database....

I am doing one of the Microsoft virtual labs "Creating ASP.NET Web Applications with C# - Part 2" using Visual Web Developer Express. I am trying to fill a gridview with database information, but it gives me the error

"An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)".

This is on the local machine that I am executing the code.

public void BindGrid(string sortfield) {//Create DataAdapter to fetch data from Prodcuts table SqlDataAdapter myCommand =new SqlDataAdapter("select * from Products", myConnection);//Create dataset and fill it with Product data DataSet ds =new DataSet(); myCommand.Fill(ds,"Products");//Bind Product data to Datagrid DataView Source = ds.Tables["Products"].DefaultView; Source.Sort = sortfield; dgProducts.DataSource = Source; dgProducts.DataBind(); }

It stops on the line "myCommand.Fill(ds, "Products"); and points out the error mentioned earlier. I am not sure what to do...any help would be greatly appreciated, thanks in advance, and I apologize as well if I have not pointed out enough information.

What does your connection string look like?|||

check this link for help:

http://support.microsoft.com/kb/914277/en-us

Thanks

|||

First of all, thank you both greatly for responding.

Smalltalk, here is the connection string:

myConnection = new SqlConnection("server=localhost;database=northwind;Trusted_Connection=yes");

Jpazgier, my connections are set at local and remote connections, plus the server is on the same machine, I have no idea why it mentions that error for me.

Thanks again, guys.

|||

Hi GWShane,

Please make sure that the server is the default instance on your machine. If you're using SQL Express, the default name for this instance might be SQLExpress. In this case, you might need to add the instance name to the DataSource like:

myConnection = new SqlConnection("server=localhost\\SQLExpress;database=northwind;Trusted_Connection=yes");

HAVING PROBLEMS INSTALLING THE SQL 2005 EXPRESS

hello, I am having some problems installing the sql 2005 express that comes with the asp.net 2.0

It says that the installation failed thats all. Anyone with that kind of problem?

Installation failure is not so easy to troubleshoot... If you had installed beta version of VS2005, you'd better uninstall the existing components completely. Here is a uninstall tool for VS2005:

http://msdn.microsoft.com/vstudio/support/uninstall/default.aspx

If you want to troubleshoot the installation, you can take a look at these posts:

http://forums.asp.net/thread/1290342.aspx

http://forums.asp.net/thread/1306350.aspx

Having Problems Installing SQL Server 2005 Express

I am running WinXP Home edition, and I was trying to install SQL Server Express, but the error message is too vague for me fix. It says my computer lacks the "Service Pack Requirements" to run the software, but I'm afraid I don't know which service pack requirements the error is talking about. What Service Pack do I need to download?

Here is the report from the install:

System Configuration Check

- WMI Service Requirement (Success)

Messages

WMI Service Requirement

Check Passed

- MSXML Requirement (Success)

Messages

MSXML Requirement

Check Passed

- Operating System Minimum Level Requirement (Success)

Messages

Operating System Minimum Level Requirement

Check Passed

- Operating System Service Pack Level Requirement. (Error)

MessagesOperating System Service Pack Level Requirement.

The current operating system does not meet Service Pack level requirements for this SQL Server release. Install the most recent Service Pack from the Microsoft download center at http://go.microsoft.com/fwlink/?LinkId=50380, and then run SQL Server Setup again. For hardware and software requirements, see the readme file or SQL Server Books Online.

- SQL Server Edition Operating System Compatibility (Success)

Messages

SQL Server Edition Operating System Compatibility

Check Passed

- Minimum Hardware Requirement (Warning)

Messages

Minimum Hardware Requirement

The current system does not meet the recommended hardware requirements for this SQL Server release. For detailed hardware and software requirements, see the readme file or SQL Server Books Online.

- Pending Reboot Requirement (Success)

Messages

Pending Reboot Requirement

Check Passed

- Default Installation Path Permission Requirement (Success)

Messages

Default Installation Path Permission Requirement

Check Passed

- Internet Explorer Requirement (Success)

Messages

Internet Explorer Requirement

Check Passed

- COM Plus Catalog Requirement (Success)

Messages

COM Plus Catalog Requirement

Check Passed

- ASP.Net Version Registration Requirement (Success)

Messages

ASP.Net Version Registration Requirement

Check Passed

- Minimum MDAC Version Requirement (Success)

Messages

Minimum MDAC Version Requirement

Check Passed

- Edition Change Check (Success)

Messages

Edition Change Check

Check Passed

THe same requirements for Windows XP Professional applies to XP Home:

http://www.microsoft.com/sql/editions/express/sysreqs.mspx

YOu nedd SP2 in order to have the setup working.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||I am having the same problem. But I have XP Professional SP2 installed. What more could I need?|||I don′t know if that also applies to the .NET Framework existance, because I already has it on my computers. But do you have .NET Framework installed (2.0) ?

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

I installed the Sp2 and problem resolved

Having Problems Installing SQL Server 2005 Express

I am running WinXP Home edition, and I was trying to install SQL Server Express, but the error message is too vague for me fix. It says my computer lacks the "Service Pack Requirements" to run the software, but I'm afraid I don't know which service pack requirements the error is talking about. What Service Pack do I need to download?

Here is the report from the install:

System Configuration Check

- WMI Service Requirement (Success)

Messages

WMI Service Requirement

Check Passed

- MSXML Requirement (Success)

Messages

MSXML Requirement

Check Passed

- Operating System Minimum Level Requirement (Success)

Messages

Operating System Minimum Level Requirement

Check Passed

- Operating System Service Pack Level Requirement. (Error)

MessagesOperating System Service Pack Level Requirement.

The current operating system does not meet Service Pack level requirements for this SQL Server release. Install the most recent Service Pack from the Microsoft download center at http://go.microsoft.com/fwlink/?LinkId=50380, and then run SQL Server Setup again. For hardware and software requirements, see the readme file or SQL Server Books Online.

- SQL Server Edition Operating System Compatibility (Success)

Messages

SQL Server Edition Operating System Compatibility

Check Passed

- Minimum Hardware Requirement (Warning)

Messages

Minimum Hardware Requirement

The current system does not meet the recommended hardware requirements for this SQL Server release. For detailed hardware and software requirements, see the readme file or SQL Server Books Online.

- Pending Reboot Requirement (Success)

Messages

Pending Reboot Requirement

Check Passed

- Default Installation Path Permission Requirement (Success)

Messages

Default Installation Path Permission Requirement

Check Passed

- Internet Explorer Requirement (Success)

Messages

Internet Explorer Requirement

Check Passed

- COM Plus Catalog Requirement (Success)

Messages

COM Plus Catalog Requirement

Check Passed

- ASP.Net Version Registration Requirement (Success)

Messages

ASP.Net Version Registration Requirement

Check Passed

- Minimum MDAC Version Requirement (Success)

Messages

Minimum MDAC Version Requirement

Check Passed

- Edition Change Check (Success)

Messages

Edition Change Check

Check Passed

THe same requirements for Windows XP Professional applies to XP Home:

http://www.microsoft.com/sql/editions/express/sysreqs.mspx

YOu nedd SP2 in order to have the setup working.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||I am having the same problem. But I have XP Professional SP2 installed. What more could I need?|||I don′t know if that also applies to the .NET Framework existance, because I already has it on my computers. But do you have .NET Framework installed (2.0) ?

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

I installed the Sp2 and problem resolved

Having Problems Installing SQL Server 2005 Express

I am running WinXP Home edition, and I was trying to install SQL Server Express, but the error message is too vague for me fix. It says my computer lacks the "Service Pack Requirements" to run the software, but I'm afraid I don't know which service pack requirements the error is talking about. What Service Pack do I need to download?

Here is the report from the install:

System Configuration Check

- WMI Service Requirement (Success)

Messages

WMI Service Requirement

Check Passed

- MSXML Requirement (Success)

Messages

MSXML Requirement

Check Passed

- Operating System Minimum Level Requirement (Success)

Messages

Operating System Minimum Level Requirement

Check Passed

- Operating System Service Pack Level Requirement. (Error)

MessagesOperating System Service Pack Level Requirement.

The current operating system does not meet Service Pack level requirements for this SQL Server release. Install the most recent Service Pack from the Microsoft download center at http://go.microsoft.com/fwlink/?LinkId=50380, and then run SQL Server Setup again. For hardware and software requirements, see the readme file or SQL Server Books Online.

- SQL Server Edition Operating System Compatibility (Success)

Messages

SQL Server Edition Operating System Compatibility

Check Passed

- Minimum Hardware Requirement (Warning)

Messages

Minimum Hardware Requirement

The current system does not meet the recommended hardware requirements for this SQL Server release. For detailed hardware and software requirements, see the readme file or SQL Server Books Online.

- Pending Reboot Requirement (Success)

Messages

Pending Reboot Requirement

Check Passed

- Default Installation Path Permission Requirement (Success)

Messages

Default Installation Path Permission Requirement

Check Passed

- Internet Explorer Requirement (Success)

Messages

Internet Explorer Requirement

Check Passed

- COM Plus Catalog Requirement (Success)

Messages

COM Plus Catalog Requirement

Check Passed

- ASP.Net Version Registration Requirement (Success)

Messages

ASP.Net Version Registration Requirement

Check Passed

- Minimum MDAC Version Requirement (Success)

Messages

Minimum MDAC Version Requirement

Check Passed

- Edition Change Check (Success)

Messages

Edition Change Check

Check Passed

THe same requirements for Windows XP Professional applies to XP Home:

http://www.microsoft.com/sql/editions/express/sysreqs.mspx

YOu nedd SP2 in order to have the setup working.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||I am having the same problem. But I have XP Professional SP2 installed. What more could I need?|||I don′t know if that also applies to the .NET Framework existance, because I already has it on my computers. But do you have .NET Framework installed (2.0) ?

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

I installed the Sp2 and problem resolved

Having problems finding Sql server with VS 2005

I have upgraded to VS 2005 and using SQL server 2005 express. I have the SQL server up and running using the managment tools and have created a small simple database. I want to connect to it using the Server Explorer window in visual studio but it does not appear? I have had it sometimes but when i do I am unable to attach or select any databases that are there?

Can anyone tell me were i am going wrong? Is it because i have upgraded from an older version?
The server create and lets me add record to the tables i make, visual studio loads and i can create pages but making them talk is proving hard when it shouldnt. any help appreciated.

Nick

PS

the error i get is:

Could not find row in sysindexes for database ID 5, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexes. Could not open new database 'Friends_Data'. CREATE DATABASE is aborted. Could not attach database 'Friends_Data' to file 'c:\Documents and Settings\NBannister\My Documents\Visual Studio 2005\WebSites\Friends.MDF'.

The following article describes the procedure for attaching AW. You can use it as the template for attaching other databases.

http://msdn2.microsoft.com/en-us/library/ms310325.aspx

Having Problem with SQL Express 2005

I just started working with sql server 2005 and i have a windows-based application in C# with an attached sql server database file.Everything is ok but i don't know if i can create a password for that database.
there is no IDE for sql server 2005 like Enterprise Manager in SQL Server 2000 to do such things(Creating roles,passwords,...).In my computer I've installed VS 2005 Professional and SQL Express.I think i should do all thease thing with system stored procdures right? But it's really boring do all those things without an IDE.

Thanks in advance.

If you have a look at the following link you will find a download for SQL Server Management Studio Express, this is an IDE based of the full management studio (Replacement for Enterprise manager and Query tools) that can be used for the express editions.

http://msdn.microsoft.com/vstudio/express/sql/download/

|||Thank you

Having problem with my server

I just currently installed Microsoft studio express which includes SQL server and i get this error Server Error in '/WebSite1' Application. it also states "Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding" I am wondering do i have to have IIS on to run SQL server 2005 express adition.

I am also having problem with SQL Express installation. After installing it, and configuring with SQL surface area for also remote access via tcp or pipe I still get the message:

>sqlcmd

HResult 0x2, Level 16, State 1
Named Pipes Provider: Could not open a connection to SQL Server [2].
Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred while establi
shing a connection to the server. When connecting to SQL Server 2005, this failu
re may be caused by the fact that under the default settings SQL Server does not
allow remote connections..
Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired.

|||Make sure you have followed all of the steps at http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx in order to enable remote connectivity.

Having connection problems with SQL Server 2005 Express

This is a bit of a cross-post from the VS 2005 Forum, but we don't have a forum dedicated to SQL Server 2005...
This is on my test machine running Windows XP Pro SP2 (NTFS),
I have an existing SQL 2000 database located on a separate hard drive dedicated to data -- the e:\ drive.
I just installed SQL Server 2005 Express, in the default installation directory (c:\Program Files\Microsoft SQL Server) and I cannot connect to that database on the e:\ drive. Named pipes, error: 40 (Remote access services are not installed by default).
I don't want the database physically located on the c:\ drive.
I've been looking all over for the solution for this, and can't find it.
Advice or direction to reference materials would be appreciated.
TinkerWell, this was REALLY hard to solve - unneccessarily hard, I'm thinking - but I have (finally) solved it.
- Tinker|||Is is too much to ask what was the solution?
I dont understand people who post like "i found the solution, bye".

|||I don't know if I made a mistake in the initial software installation that caused this problem, the question hadn't garnered many views or much interest, and received no replies, but nonetheless: I'm sorry!
What worked for me was to uninstall SQL Server and when I reinstalled it, I chose the option to NOT install any of the sample databases that are included with the package. By not installing the samples the SQL Server Managment utility then allowed me to ATTACH to existing databases on a separate data drive. With the samples installed, I could not get ATTACH to work with my remote database.
And I didn't install the samples the second time around because I couldn't see any option to mount the samples on the same hard drive as my existing databases; they are installed in the SQL Server program folder by default. So the second time around, I chose to not install them and see if that made a difference -- and that seemed to have solved the problem I had getting ATTACH to work.
But let me empahsize that I don't know if I made a mistake during the original software install that prevented ATTACHING to my databases on a separate hard drive, and I haven't received a reply from Microsoft, yet, about whether I made a mistake.
And I don't know if dropping/deleting the sample databases would have been just as effective and much faster. I didn't try it. I had fiddled around so much trying to get ATTACH to work that I didn't trust the condition of the Server, and just started over with fresh installs. But knowing what I know now, I would have tried droppng the samples and seeing if that allowed me to ATTACH to a database on a different hard drive.
Hope this helps. When I hear back from MS, I'll let you know what they said, and whether the probelm was an undocumented feature, or my brain-fart,
Tinker|||Okay, sorry about that "angry mood" in my previous post but i was losing my mind with sql connection.
Resolved it by using right host/instance name :-)
cheer's
bassock

Has anyone had timeout problems when backup up an Express database?

I was always able to backup until my data went over approximately 500 meg. Now when the backup is running it times out. I checked the Express settings and all timeout parameters are set at 60 seconds. But the backup times out at about 30 seconds.

The message is

TITLE: Microsoft SQL Server Management Studio Express

Backup failed for Server 'MYEXP\SQLEXPRESS'. (Microsoft.SqlServer.Express.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Backup+Server&LinkId=20476

ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. (Microsoft SQL Server, Error: -2)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=-2&LinkId=20476

Hey Expressman,

Since you're doing your backup using Management Studio Express, I'm going to move this thread over to the Tools forum where SSMSE questions are answered.

- Mike

Hardware compatability

Does SQL Server Express Edition work with a Pentium M computer? When I downloaded it there was a message that it wasn't the proper hardware but everything else fits the requirements for an install.
Did you install .Net framework >2.0 and Wininstaler 3.0?

Which version your operational system is?|||I installed everything in the order that is directed by the SQL Server Express Edition site. When I installed SQL Server Express, it did install successfully on my desktop, which is a Pentium IV, Windows XP Professional machine. However, when installed on my laptop, a Pentium M, Windows XP Professional, machine, everything installed except for a warning sign which said the hardware is incompatible. In checking my properties section on My Computer, everything else matches the requirements for an install and I have enough hard drive space and RAM. That's why I was wondering if a Pentium M system will handle the SQL Server Express Edition install.|||What's the service pack instaled on your Windows ?|||Windows SP2
|||Which speed you CPU is?|||My system is:
Intel Pentium M
1.60GHz
590MHz
504 MB of Ram
19 GB hard drive space available

Hardware compatability

Does SQL Server Express Edition work with a Pentium M computer? When I downloaded it there was a message that it wasn't the proper hardware but everything else fits the requirements for an install.

Did you install .Net framework >2.0 and Wininstaler 3.0?

Which version your operational system is?|||

I installed everything in the order that is directed by the SQL Server Express Edition site. When I installed SQL Server Express, it did install successfully on my desktop, which is a Pentium IV, Windows XP Professional machine. However, when installed on my laptop, a Pentium M, Windows XP Professional, machine, everything installed except for a warning sign which said the hardware is incompatible. In checking my properties section on My Computer, everything else matches the requirements for an install and I have enough hard drive space and RAM. That's why I was wondering if a Pentium M system will handle the SQL Server Express Edition install.

Thanks for your help on this.

|||

What's the service pack instaled on your Windows ?

|||

Windows SP2

|||

Which speed you CPU is?

|||

My system is:
Intel Pentium M

1.60GHz

590MHz

504 MB of Ram

19 GB hard drive space available

Hardware compatability

Does SQL Server Express Edition work with a Pentium M computer? When I downloaded it there was a message that it wasn't the proper hardware but everything else fits the requirements for an install.

Did you install .Net framework >2.0 and Wininstaler 3.0?

Which version your operational system is?|||

I installed everything in the order that is directed by the SQL Server Express Edition site. When I installed SQL Server Express, it did install successfully on my desktop, which is a Pentium IV, Windows XP Professional machine. However, when installed on my laptop, a Pentium M, Windows XP Professional, machine, everything installed except for a warning sign which said the hardware is incompatible. In checking my properties section on My Computer, everything else matches the requirements for an install and I have enough hard drive space and RAM. That's why I was wondering if a Pentium M system will handle the SQL Server Express Edition install.

Thanks for your help on this.

|||

What's the service pack instaled on your Windows ?

|||

Windows SP2

|||

Which speed you CPU is?

|||

My system is:
Intel Pentium M

1.60GHz

590MHz

504 MB of Ram

19 GB hard drive space available

Handling Null fields with three-tier architecture

I using Visual Web Designer Express (with Visual Basic), with a SQL Server 2000 database. I have a prototype application running satisfactorily using code that builds queries, but I'm now trying to rebuild the application "properly" using three-tier architecture. I have been following the principles of Scott Mitchell's tutorials. I have created an database .xsd with a table adaptor, and replaced the rather grotty query-building code in the business layer with better code referencing the table adaptor. Thus where the first version had code: -

Dim queryString As String = "SELECT * FROM NZGDB_User WHERE USRid = '" & Userid & "'"
Dim message As String = ""
Dim Found As Boolean = False
Try
Using connection As New SqlConnection(GDB_AppSettings.Connection)
Dim command As New SqlCommand(queryString, connection)
connection.Open()

Dim reader As SqlDataReader = command.ExecuteReader()

If reader.Read() Then
Found = True
_USRid = reader("USRid")
_USRPassword = reader("USRPassword")
_USREmail = reader("USREmail")
_USRTitle = reader("USRTitle")
_USRName = reader("USRName")
_USRRole = reader("USRRole")
If IsDBNull(reader("USRAgreedConditions")) = False Then
_USRAgreedConditions = reader("USRAgreedConditions")
End If
End If
reader.Close()
End Using
Catch ex As Exception
If Left(Err.Description, 68) = "An error has occurred while establishing a connection to the server." Then
Return "Cannot open database to logon"
Else
Return Err.Description
End If
End Try

the new version is much more elegant: -

Dim taUser As New NZGDBTableAdapters.NZGDB_UserTableAdapter()

Dim tbUser As NZGDB.NZGDB_UserDataTable = taUser.GetUserByUserid(userid)
If tbUser.Count <> 1 Then ' Anything other than 0 or 1 should be impossible
Return "User not found"
End If

Dim trUser As NZGDB.NZGDB_UserRow = tbUser(0)
_USRid = userid
_USRPassword = password
_USREmail = trUser.USREmail
_USRTitle = trUser.USRTitle
_USRName = trUser.USRName
_USRRole = trUser.USRRole
_USRAgreedConditions = trUser.USRAgreedConditions

However, there is a problem. The database field USRAgreedConditions is a Datetime field that can be null. The new version works perfectly when it is NOT null, but throws an exception: -

System.Data.StrongTypingException was unhandled by user code
Message="The value for column 'USRAgreedConditions' in table 'NZGDB_User' is DBNull."
Source="App_Code.wt2vzoc1"
...

There is no point in writing: -
If Not IsDBNull(trUser.USRAgreedConditions) Then
_USRAgreedConditions = trUser.USRAgreedConditions
End If
because the exception occurs within the automatically-created code in the data access layer. I tried changing the Nullvalue property of the field USRAgreedConditions in the table adaptor, but the only valid option is (Throw Exception) unless the field is a String. Of course USRAgreedConditions is a Datetime field, so I can't change the property.

It seems that my only options are: -
1. To stick with the old query-building code. But this doesn't give me the advantages of a proper 3-tier architecture
2. To change the generated code in wt2vzoc. This MUST be a bad idea - surely I should leave this code untouched. Besides, what if the table adaptor has to be regenerated when I change the table design?
3. Code a Try block within the business layer: -
Try
_USRAgreedConditions = trUser.USRAgreedConditions
Catch exAs Exception
_USRAgreedConditions =Nothing
EndTry

This seems to work OK, but seems less elegant than the original code in the old version: -
If IsDBNull(reader("USRAgreedConditions")) = False Then
_USRAgreedConditions = reader("USRAgreedConditions")
End If

Is there a better way?

Hi Robert my friend,

There is a better way. Change your query to list all of the fields within the table that you want and set the USRAgreedConditions field to a specific valid date if it is NULL via the ISNULL() function. The SQL below will return today's date in this field where it is NULL but you can change it to use any valid date value that you wish.

SELECT USRid, USRPassword, URSEmail, USRTitle, USRName, USRRole,

ISNULL(USRAgreedConditions, GetDate()) AS USRAgreedConditions

FROM NZGDB_User

For this reason, it is not good practice to rely solely on date fields for business logic. If this field being null indicates that the conditions have not been agreed yet, it would be better to have an additional BIT field that indicates Yes or No and then the USRAgreedConditions field would simply be a field containing the date information for those that are set to 1 (Yes).

Kind regards

Scotty

|||

Thanks Scotty, that's certainly a neater solution, and I'll progressively use it. Unfortunately my code is now riddled with Try/End try blocks to handle Null fields, so it will take some time to get rid of them all.

Your solution will certainly work in most, perhaps all, of my situations. However I wonder if there isn't a lurking problem. The point of NULL is to distinguish "No value" from "Default value". Sometimes you need to make the distinction in your code, and there is a risk that whatever value you choose for VALUE in
ISNULL(USRAgreedConditions, VALUE) AS USRAgreedConditions
will coincide with a real value. Getdate() won't do, and neither will 0 (which becomes 1/1/1900) as either could be a valid date in this application. In this case I can use Getdate()+20 and test for a future date (which is otherwise logically impossible), but I have to be careful to remember to check that my logic doesn't write these artificial values back to the database. I tried using
DIM USRAgreeConditions as NULLABLE (OF Datetime)
but found myself getting into a lot of trouble with errors popping up elsewhere.

It's a pity that the designers of the new NULLABLE feature didn't make the handling of all potentially-null fields consistent. Thus I find that there is little trouble with String fields (CHAR, VARCHAR, etc in the database), as I can simply set the column's Nullvalue property to Empty. It's just silly that I can't do this for GUID and Date (and any other type) fields. There are also some idiocies in the way that operator usage changes with NULLABLE fields. Enough raving!

Thanks for your help.

Regards, Robert

|||

Hi Robert,

You can also try this within the query. In addition to generating a valid date for your column, have another column that inidcates whether or not it was generated so that you can check this extra column in the code to determine how to process the date field: -

SELECT ISNULL(USRAgreedConditions, GetDate()) AS USRAgreedConditions,
CASE WHEN USRAgreedConditions IS NULL THEN 'Yes' ELSE '' END AS IsNullDate
FROM TableName

Kind regards

Scotty

|||

Thanks Scotty, yes that's exactly what I want. Something like this (returning the default value of Nothing and an indicator of whether it's a real null or not is what Microsoft should be doing automatically: in the meantime I guess this is the best we can do.

Thanks again, Robert