Showing posts with label express. Show all posts

Friday, March 30, 2012

Problem Running Sql Server 2005 Express on Vista

I have been trying to get Sql Server 2005 Express Advanced with SP2 installed and operating on my Vista machine. It seems to install ok but when I open Management Studio Express and try to create a new db or attach an existing one, I get error messages. So although it seems to be installed, I can't really use it.

When I try to create a new database I get:

TITLE: Microsoft SQL ServerManagement Studio Express

----------

Create failed for Database'practice'. (Microsoft.SqlServer.Express.Smo)

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

----------

ADDITIONAL INFORMATION:

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

----------

CREATE DATABASE permission denied indatabase 'master'. (Microsoft SQL Server, Error: 262)

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

----------

BUTTONS:

----------

When I try to attach an existing database I get:

TITLE: Microsoft SQL ServerManagement Studio Express

----------

Failed to retrieve data for thisrequest. (Microsoft.SqlServer.Express.SmoEnum)

For help, click:http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476

----------

ADDITIONAL INFORMATION:

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

----------

The server principal"Dave-PC\Dave" is not able to access the database "model"under the current security context. (Microsoft SQL Server, Error: 916)

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

----------

BUTTONS:

----------

I have tried following the links in the error messages but the result is: "We're sorryThereis no additional information about this issue in the Error and EventLog Messages or Knowledge Base databases at this time. You can use thelinks in the Support area to determine whether any additionalinformation might be available elsewhere."

I am successfully using both programs on my XP SP2 machines, so I know how to install and run them on XP, just not on Vista (yet). Any suggestions on how to proceed?

I had alot of VS issues when I switched to Vista. Are you running the management studio as an admin? As a test you may want to turn off UAC and see if that fixes your issue. If it does then you just need to change the permissions that you are running with.

|||

Thanks for the suggestion. It worked and I am able to run Sql Server 2005 Express via Management Studio to create and attached databases.

Question: Do I have to toggle the UAC on and off every time I want to use SQL Server Express (or leave it off always if I am willing to accept the security issues)? Or do I have other options?

|||

I personally turned mine off just because I am the only user of the PC and I'm fairly certain that if I was going to do something harmful to my own PC I'd just turn UAC off at the time I was doing it anyway. There is however a way to set the program to always run in admin mode. I'm on an XP machine right now so I can't post instructions myself but step 3 in the below article should be what you need.

http://4sysops.com/archives/vista%E2%80%99s-uac-8-ways-how-to-elevate-an-application-to-run-it-with-administrator-rights/

|||

Thanks for help. I hope I get equally good advice as I sort out some of my other Vista problems!

Wednesday, March 28, 2012

Problem returning data

I have a stored procedure (in SQL Server 2005 Express) that returns a string. The problem is when I call it from my web page I get only the first character of the string. This is my SP:

ALTER PROCEDURE

dbo.usp_CalcDeliveryCharge

@.mintDistance

int,

@.mintCustomer_ID

int= 0,

@.mintRate

int= 0OUTPUT,

@.mstrZone

nchar(10) =null OUTPUT

/* SET NOCOUNT ON */SELECT@.mintRate=RATE,

@.mstrZone=ZONE

FROMtblRatesWHERECustomer_ID=@.mintCustomer_IDANDMile_Range_Min <= @.mintDistanceANDMile_Range_Max >= @.mintDistance

And this is my code:

sql_Command.CommandText =

"usp_CalcDeliveryCharge"

sql_Command.CommandType = CommandType.StoredProcedure

sql_Command.Parameters.Clear()

sql_Command.Parameters.AddWithValue(

"@.mintDistance", intApproxMiles)

sql_Command.Parameters.AddWithValue(

"@.mintCustomer_ID", Profile.CompanyID)

sql_Conn.Open()

sql_Reader = sql_Command.ExecuteReader()

While (sql_Reader.Read())Me.lblZone.Text = sql_Reader.Item(0).ToStringEndWhile

sql_Conn.Close()

sql_Reader.Close()

sql_Command.Dispose()

If you are using OUTPUT parameters you need to add the output parameters in the asp.net code also and set their direction as output and retrieve the values through those parameters not through datareader.
checkthis article if it helps.

Problem Restoring Database

I have a backup of a database from SQL Server. I try to restore that backup file to SQL Server Express and get the following error:

Cannot open backup device 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\TEST.BAK'. Operating system error 5(Access is denied.).
RESTORE HEADERONLY is terminating abnormally. (.Net SqlClient Data Provider)

When restoring other files, I would get this same error message, copy it to another folder and it would work. With this particular one, no matter what folder I copy it to I get the same error message. From what I can find online is that its a permission thing, but I cant find anywhere to change the permissions.

Any help is appreciated.

That can be based on serveral problems which either depends on the way you authenticate to the database server (you did not mention that) and the service account (running SQL Server authentication) or you own account (running Windows authenticaiton) does not have the appropiate rights to access the folder or you are running Vista, which needs elevated rights to access the special folder opn your system.

Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||I connect using mixed authentication. I am running windows XP.|||

I have hit this issue, detaching a database then copying the .mdf file then attempting to attach on another server.

The 'copied-to' server in my case is running on Vista. I eventually bludgeoned it into working by opening up all the permissions on the containing folder and the .mdf file itself; so I guess this tends to confirm it's a permissions issue, but 'just give everyone access to everything' isn't really a satisfactory answer! Can anyone point us in the direction of more detail on how permissions and SQL Express interact - I gather it's particularly tricky with Vista and UAC etc. Jens - could you expand on the bit about Vista and the 'special folder' - I take it you mean the folder containing the .mdf?

TIA

|||What I ended up doing was setting the mssql folder proprty to full access and took read only off and it worked. Thanks.|||There's some more about this issue here: http://msdn2.microsoft.com/en-us/library/ms189128.aspx

Problem Restoring Database

I have a backup of a database from SQL Server. I try to restore that backup file to SQL Server Express and get the following error:

Any help is appreciated.

Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||I connect using mixed authentication. I am running windows XP.|||

I have hit this issue, detaching a database then copying the .mdf file then attempting to attach on another server.

TIA

Wednesday, March 21, 2012

Problem opening SSMS Express

Hi,
I experience a problem after installing "SQL Server 2005 Books On Line"
(December 2005) on my notebook, which have also an installation of SQL
Server 2005 Express Edition. Management Studio Express Edition (November
CTP) don't start...
If I try to open it, nothing happens. Anyone can help me?
Thanks
David
David wrote:
> Hi,
> I experience a problem after installing "SQL Server 2005 Books On Line"
> (December 2005) on my notebook, which have also an installation of SQL
> Server 2005 Express Edition. Management Studio Express Edition (November
> CTP) don't start...
> If I try to open it, nothing happens. Anyone can help me?
> Thanks
I find the solution:
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=57857
David

Tuesday, March 20, 2012

Problem on collation on SQL Server Express with Windows Mobile 5.0

I am now writing application to connect SQL Server Express in Windows Mobile 5.0.

While running the code, I got error "PlatformNotSupportedException". I realized that it is a problem on different locale on the PDA and the SQL Server. So I tried to re-install the SQL Server for another collation, which is Latin1_General_CI_AI. I have also set the collation to Latin1_General_CI_AI at database-level.

Unfortunately, in the Visual Studio Debugger, I found that the error message is

mscorlib.dll!System.Globalization.CultureInfo.CultureInfo(int culture = 3076, bool useUserOverride = true) + 0xc8 bytes

where the 3076 means Chinese (Hong Kong SAR, PRC) locale from MSDN.

Seems to me that I cannot really change the collation in this Express Edition.

How can I solve it?

Thanks

Hi Billy,

You can not change the Server setting for Collation order once SQL Express is installed, but you can set collation on a per database basis when you created it. I'm not sure if you can change the database collation order after it's created, but if you look up ALTER DATABASE in Books Online, I'm sure you'll find the answer.

Beyond that, where exactly are you installing SQL Express again? SQL Express wouldn't install on Windows Mobile 5.0 so you must be writing an app that connects to a server running SQL Express, or you are actually using SQL Compact Edition. If you are using SQLce, then you should post this question in the SQLce forum.

Mike

|||

Thanks Mike!

"You can not change the Server setting for Collation order once SQL Express is installed, but you can set collation on a per database basis when you created it. I'm not sure if you can change the database collation order after it's created, but if you look up ALTER DATABASE in Books Online, I'm sure you'll find the answer."

-> Yes, I understand that I cannot change Server Setting for Collation after installation. So I DID remove the whole SQL Server Express, and then install it again. At that moment, I selected "SQL_Latin1_General_CP1_CI_AI", that's also what I can see from the SQL Server Management window. It is the same for the database collation setting, which was set to "SQL_Latin1_General_CP1_CI_AI"

So, the problem comes that the actual running in the debugger shows a different collation (Chinese Hong Kong) while it run sqlclient code in the PDA. => That is for sure a contradiction with the server setting. So, what's the problem on this case and how to solve it?

"Beyond that, where exactly are you installing SQL Express again? SQL Express wouldn't install on Windows Mobile 5.0 so you must be writing an app that connects to a server running SQL Express, or you are actually using SQL Compact Edition. If you are using SQLce, then you should post this question in the SQLce forum."

I am using SQL Express in a local PC. And I try to write app using VB on PDA which connects to the PC SQL server.

|||

Hi Billy,

What code are you running to show the collation? Please provide a sample. Do you see similar results if you take the PDA out of the scenario and run code directly on the machine where SQL is installed?

Mike

|||

Hi Mike,

Well, below is the code I run.

Dim sqlConnection1 AsNew SqlConnection("Data Source=BILLY\SQLEXPRESS;Initial Catalog=rfidcps;Persist Security Info=True;User ID=*****; Password=******;")

Dim cmd AsNew SqlCommand

Dim reader As SqlDataReader

cmd.CommandText = "SELECT * FROM Vehicle WHERE MainTagID = '" & "434" & "'"

Dim i AsInteger = 0

cmd.CommandType = CommandType.Text

cmd.Connection = sqlConnection1

sqlConnection1.Open()

reader = cmd.ExecuteReader()

And, the error comes out from executing "reader = cmd.ExecuteReader()", which shows something like this

System.PlatformNotSupportedException was unhandled
Message="PlatformNotSupportedException"
StackTrace:
at System.Globalization.CultureInfo..ctor()
at System.Globalization.CultureInfo..ctor()
at System.Data.SqlClient.TdsParser.GetCodePage()
at System.Data.SqlClient.TdsParser.ProcessEnvChange()
at System.Data.SqlClient.TdsParser.Run()
at System.Data.SqlClient.TdsParser.Run()
at System.Data.SqlClient.SqlInternalConnection.Login()
at System.Data.SqlClient.SqlInternalConnection.OpenAndLogin()
at System.Data.SqlClient.SqlInternalConnection..ctor()
at System.Data.SqlClient.SqlConnection.Open()
at System.Data.Common.DbDataAdapter.QuietOpen()
at System.Data.Common.DbDataAdapter.FillInternal()
at System.Data.Common.DbDataAdapter.Fill()
at System.Data.Common.DbDataAdapter.Fill()
at DeviceApplication1.rfidcpsDataSetTableAdapters.VehicleTableAdapter.Fill()
at DeviceApplication1.Form1.Form1_Load()
at System.Windows.Forms.Form.OnLoad()
at System.Windows.Forms.Form._SetVisibleNotify()
at System.Windows.Forms.Control.set_Visible()
at System.Windows.Forms.Application.Run()
at DeviceApplication1.Form1.Main()

I asked similar question here and I found the collation requested by the server is actually not the one I set to the server

I tried to disconnect connection with the PDA and the server and it showed error in "sqlConnection1.Open()", which was absolutely the right things.

So, I drawed conclusion that the PDA can open the connection to SQL server but just failed to run "reader = cmd.ExecuteReader()"

Thanks for your help~

Best regards,

Billy

|||

I'm running this by a few folks I know to see if they have any ideas.

Mike

Problem on collation on SQL Server Express with Windows Mobile 5.0

I am now writing application to connect SQL Server Express in Windows Mobile 5.0.

Unfortunately, in the Visual Studio Debugger, I found that the error message is

mscorlib.dll!System.Globalization.CultureInfo.CultureInfo(int culture = 3076, bool useUserOverride = true) + 0xc8 bytes

where the 3076 means Chinese (Hong Kong SAR, PRC) locale from MSDN.

Seems to me that I cannot really change the collation in this Express Edition.

How can I solve it?

Thanks

Hi Billy,

Mike

|||

Thanks Mike!

I am using SQL Express in a local PC. And I try to write app using VB on PDA which connects to the PC SQL server.

|||

Hi Billy,

Mike

|||

Hi Mike,

Well, below is the code I run.

Dim sqlConnection1 As New SqlConnection("Data Source=BILLY\SQLEXPRESS;Initial Catalog=rfidcps;Persist Security Info=True;User ID=*****; Password=******;")

Dim cmd As New SqlCommand

Dim reader As SqlDataReader

cmd.CommandText = "SELECT * FROM Vehicle WHERE MainTagID = '" & "434" & "'"

Dim i As Integer = 0

cmd.CommandType = CommandType.Text

cmd.Connection = sqlConnection1

sqlConnection1.Open()

reader = cmd.ExecuteReader()

And, the error comes out from executing "reader = cmd.ExecuteReader()", which shows something like this

I asked similar question here and I found the collation requested by the server is actually not the one I set to the server

I tried to disconnect connection with the PDA and the server and it showed error in "sqlConnection1.Open()", which was absolutely the right things.

So, I drawed conclusion that the PDA can open the connection to SQL server but just failed to run "reader = cmd.ExecuteReader()"

Thanks for your help~

Best regards,

Billy

|||

I'm running this by a few folks I know to see if they have any ideas.

Mike

problem of uploading asp.net website on web server

i have developed a website using asp.net, c# withSQL SERVER EXPRESS EDITION 2005. The database is being used both for retreival and updation purpose. the website is working accordingly when i m running it on my system, ie., data is getting retreived from the database and it is also getting updated on button click. But when i m uloading my site on the httpdocs folder of web server, connectivity with database is failing miserably, ie neither getting retreived from the database nor getting updated. The error message displayed by the web server is given underneath. i have used Grid view for displaying data from the database and Details view for updating the database.

i have used window authentication for connecting with the database.

Please help me with finding out a solution for it. give me proper explanation and i need to do

Server Error in '/' Application.

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)

Description:An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details:System.Data.SqlClient.SqlException: 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)

smartymca:
this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections

Have you checked to see if this is the case or not? Simply pasting this error into google should show you how to do this.

|||

Hello smartymca,

I have recently uploaded my first ASP.NET website to the web, and I had exactly the same problem and error message. I found there were two reasons for this:

1. My hosting company require that my SQL Server database be located on a different server to the rest of my files! So check with your provider to see if your database needs to be in a specific place. I had to remove my database from my App_Data folder and recreate it on the correct server. I also had to change the connection string in my application to match the database's new location.

2. Now that my database was on a different server, the login system didn't work! This was because the default connection string for the Membership provider was no longer valid. There is however a very good video on this website that guides you through setting this up. It's the"ASP.NET How Do I? #13" video.

I hope this helps. If you think your problem is caused by the same thing then write back and maybe I can help.

|||

You will probably want to you SQL authentication because chances are, the SQL Server and the application server are on two different servers.

Who is your host?

|||

my web services provider is PROWEBS (prowebs.co.in).

|||

thanks for your reply. Yes i think my problem is same as your's, so please guide me.

My provider is (prowebs.co.in).

Tell me the steps you followed.

|||

smarty,

I've had a look at your provider's website and it appears to be exactly the same setup as my provider. You have to place your SQL Server database on a specific server for it to work - in your case, it is the "3Essentials MSSQL" server.

Unfortunately you cannot simply copy your existing database to the server (I had the same problem). A new empty database must be created on the 3Essentials server. Then, there are two things you can do.

If your database is still quite small and simple, you could recreate the tables yourself by connecting to your new database through MS Visual Studio. This is what I did.

If your database already has a lot of data in it and would take too long to recreate, you can transfer the data from your old database to your new database. This requires making a backup of your database using MS SQL Enterprise Manager (supposedly free to download from Microsoft, although when I tried, the download wasn't there) and then sending this backup to your provider so they can upload it for you. Detailed instructions can be found in your provider's FAQ.

smarty - are you using MS Visual Studio? If so, and you would like to try the first option, let me know and perhaps I could walk you through it. Send me a private message.

Patrick

|||

Patrick,

thnx for ur prompt reply..........

yes i m using MS Visual Studio and m also interested in using the first option............So, plz guide me through...........

|||

Ok,

1. Login to your user account at Prowebs. Find the database management section, and create a new MS SQL 2005 database. You'll give it a name, and a username and password.

2. Find out the server address for your new database. I guess it will be something like sql.3essentials.com. Also try and find out the connection string - my hosting company has a neat tool that tells you what it is. If yours doesn't, don't worry - you can find out in Visual Studio later.

3. Open up Visual Studio 2005. Click on the View menu and choose Server Explorer. Click on 'Connect to Database'.

4. In the new window, select the following options:

Datasource: Microsoft SQL Server

|||

i didn't get the server name. i put my dbi.3Essentials.com as server name but it still showing the same error which i have already given u.

|||

smarty,

Did you go through all the steps that I gave you? If not, how far did you get?

Monday, March 12, 2012

Problem mit Stored Procedure

Die folgende Stored Procedure (MS SQL Server 2005 Express) verursacht
folgende Fehlermeldungen:
"Meldung 4104, Ebene 16, Status 1, Prozedur GetNextSequence, Zeile 11
Der mehrteilige Bezeichner "dbo.Text.text_id" konnte nicht gebunden
werden.
Meldung 4104, Ebene 16, Status 1, Prozedur GetNextSequence, Zeile 11
Der mehrteilige Bezeichner "Language_Text1.language" konnte nicht
gebunden werden."
Hier das Statement zur Generierung der Stored Procedure:
code:
"if exists (select * from dbo.sysobjects where id =3D
object_id(N'[dbo].[GetNextSequence]') and OBJECTPROPERTY(id,
N'IsProcedure') =3D 1)
drop procedure [dbo].[GetNextSequence]
GO
CREATE PROCEDURE [dbo].[GetNextSequence] (
@.article_id int,
@.language nvarchar(10)
)
AS
SET NOCOUNT ON
SELECT
[Type].[type_id],
[Language_Text].[text] AS [type_name],
[Article].[article_id],
[Language_Text_1].[text] AS [title],
[Language_Text_2].[text] AS [description],
[Image].[image_nr],
[Article].[price_chf]
FROM
[Article_Article] INNER JOIN
[Article] ON [Article_Article].[article_id2] =3D [Article].[article_id]
INNER JOIN
[Type] ON [Article].[type_id] =3D [Type].[type_id] INNER JOIN
[Image] ON [Article].[image_id] =3D [Image].[image_id] INNER JOIN
[Article] AS [Article_1] ON [Article_Article].[article_id] =3D
[Article_1].[article_id] INNER JOIN
[Text] ON [Type].[type_name] =3D [dbo.Text].[text_id] INNER JOIN
[Language_Text] ON [Text].[text_id] =3D [Language_Text].[text_id] INNER
JOIN
[Text] AS [Text_1] ON [Article].[title_id] =3D [Text_1].[text_id] INNER
JOIN
[Language_Text] AS [Language_Text_1] ON [Text_1].[text_id] =3D
[Language_Text_1].[text_id] INNER JOIN
[Text] AS [Text_2] ON [Article].[text_id] =3D [Text_2].[text_id] INNER
JOIN
[Language_Text] AS [Language_Text_2] ON [Text_2].[text_id] =3D
[Language_Text_2].[text_id]
WHERE
[Article_1].[article_id] =3D @.article_id AND [Language_Text].[language]
=3D @.language AND [Language_Text1].[language] =3D @.language AND
[Language_Text_2].[language] =3D @.language"
Weshalb funktioniert diese Stored Procedure nicht?
Gibt es irgend ein Assistent f=FCr SQL Server 2005 Express mit dem ich
bestehende Querys in Stored Procedures umwandeln kann?Es tut mir Leid; Mein Deutsch ist SCHLECHT!
Ihren Stored Procedure schauen arbeiten. Was ist Ihren TableDef?
Peace & happy computing,
Mike Labosh, MCSD MCT
Owner, vbSensei.Com
"Escriba coda ergo sum." -- vbSensei
<david.ehrler@.zone3000.ch> wrote in message
news:1150299946.218623.89270@.y41g2000cwy.googlegroups.com...
Die folgende Stored Procedure (MS SQL Server 2005 Express) verursacht
folgende Fehlermeldungen:
"Meldung 4104, Ebene 16, Status 1, Prozedur GetNextSequence, Zeile 11
Der mehrteilige Bezeichner "dbo.Text.text_id" konnte nicht gebunden
werden.
Meldung 4104, Ebene 16, Status 1, Prozedur GetNextSequence, Zeile 11
Der mehrteilige Bezeichner "Language_Text1.language" konnte nicht
gebunden werden."
Hier das Statement zur Generierung der Stored Procedure:
code:
"if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[GetNextSequence]') and OBJECTPROPERTY(id,
N'IsProcedure') = 1)
drop procedure [dbo].[GetNextSequence]
GO
CREATE PROCEDURE [dbo].[GetNextSequence] (
@.article_id int,
@.language nvarchar(10)
)
AS
SET NOCOUNT ON
SELECT
[Type].[type_id],
[Language_Text].[text] AS [type_name],
[Article].[article_id],
[Language_Text_1].[text] AS [title],
[Language_Text_2].[text] AS [description],
[Image].[image_nr],
[Article].[price_chf]
FROM
[Article_Article] INNER JOIN
[Article] ON [Article_Article].[article_id2] = [Article].[article_id]
INNER JOIN
[Type] ON [Article].[type_id] = [Type].[type_id] INNER JOIN
[Image] ON [Article].[image_id] = [Image].[image_id] INNER JOIN
[Article] AS [Article_1] ON [Article_Article].[article_id] =
[Article_1].[article_id] INNER JOIN
[Text] ON [Type].[type_name] = [dbo.Text].[text_id] INNER JOIN
[Language_Text] ON [Text].[text_id] = [Language_Text].[text_id] INNER
JOIN
[Text] AS [Text_1] ON [Article].[title_id] = [Text_1].[text_id] INNER
JOIN
[Language_Text] AS [Language_Text_1] ON [Text_1].[text_id] =
[Language_Text_1].[text_id] INNER JOIN
[Text] AS [Text_2] ON [Article].[text_id] = [Text_2].[text_id] INNER
JOIN
[Language_Text] AS [Language_Text_2] ON [Text_2].[text_id] =
[Language_Text_2].[text_id]
WHERE
[Article_1].[article_id] = @.article_id AND [Language_Text].[language]
= @.language AND [Language_Text1].[language] = @.language AND
[Language_Text_2].[language] = @.language"
Weshalb funktioniert diese Stored Procedure nicht?
Gibt es irgend ein Assistent fr SQL Server 2005 Express mit dem ich
bestehende Querys in Stored Procedures umwandeln kann?|||David,
Sie referieren an "Text" mit dem Bezeichner "dbo.Text" in:
-- "dbo." needs to be removed
INNER JOIN [Text] ON [Type].[type_name] = [dbo.Text].[text_id]
Genau so fuer den anderen Bezeichner:
-- don't forget the "_" in Language_Text_1
INNER JOIN [Language_Text] AS [Language_Text_1]
..
WHERE ... [Language_Text1].[language] = @.language
Viel Erfolg,
Gert-Jan
david.ehrler@.zone3000.ch wrote:
> Die folgende Stored Procedure (MS SQL Server 2005 Express) verursacht
> folgende Fehlermeldungen:
> "Meldung 4104, Ebene 16, Status 1, Prozedur GetNextSequence, Zeile 11
> Der mehrteilige Bezeichner "dbo.Text.text_id" konnte nicht gebunden
> werden.
> Meldung 4104, Ebene 16, Status 1, Prozedur GetNextSequence, Zeile 11
> Der mehrteilige Bezeichner "Language_Text1.language" konnte nicht
> gebunden werden."
> Hier das Statement zur Generierung der Stored Procedure:
> code:
> "if exists (select * from dbo.sysobjects where id =
> object_id(N'[dbo].[GetNextSequence]') and OBJECTPROPERTY(id,
> N'IsProcedure') = 1)
> drop procedure [dbo].[GetNextSequence]
> GO
> CREATE PROCEDURE [dbo].[GetNextSequence] (
> @.article_id int,
> @.language nvarchar(10)
> )
> AS
> SET NOCOUNT ON
> SELECT
> [Type].[type_id],
> [Language_Text].[text] AS [type_name],
> [Article].[article_id],
> [Language_Text_1].[text] AS [title],
> [Language_Text_2].[text] AS [description],
> [Image].[image_nr],
> [Article].[price_chf]
> FROM
> [Article_Article] INNER JOIN
> [Article] ON [Article_Article].[article_id2] = [Article].[article_id]
> INNER JOIN
> [Type] ON [Article].[type_id] = [Type].[type_id] INNER JOIN
> [Image] ON [Article].[image_id] = [Image].[image_id] INNER JOIN
> [Article] AS [Article_1] ON [Article_Article].[article_id] =
> [Article_1].[article_id] INNER JOIN
> [Text] ON [Type].[type_name] = [dbo.Text].[text_id] INNER JOIN
> [Language_Text] ON [Text].[text_id] = [Language_Text].[text_id] INNER
> JOIN
> [Text] AS [Text_1] ON [Article].[title_id] = [Text_1].[text_id] INNER
> JOIN
> [Language_Text] AS [Language_Text_1] ON [Text_1].[text_id] =
> [Language_Text_1].[text_id] INNER JOIN
> [Text] AS [Text_2] ON [Article].[text_id] = [Text_2].[text_id] INNER
> JOIN
> [Language_Text] AS [Language_Text_2] ON [Text_2].[text_id] =
> [Language_Text_2].[text_id]
> WHERE
> [Article_1].[article_id] = @.article_id AND [Language_Text].[language]
> = @.language AND [Language_Text1].[language] = @.language AND
> [Language_Text_2].[language] = @.language"
> Weshalb funktioniert diese Stored Procedure nicht?
> Gibt es irgend ein Assistent fr SQL Server 2005 Express mit dem ich
> bestehende Querys in Stored Procedures umwandeln kann?|||Genau das war der Fehler, jetzt klappts ohne Problem
Besten Dank!!
Gert-Jan Strik schrieb:
> David,
> Sie referieren an "Text" mit dem Bezeichner "dbo.Text" in:
> -- "dbo." needs to be removed
> INNER JOIN [Text] ON [Type].[type_name] =3D [dbo.Text].[text_id]
> Genau so fuer den anderen Bezeichner:
> -- don't forget the "_" in Language_Text_1
> INNER JOIN [Language_Text] AS [Language_Text_1]
> ...
> WHERE ... [Language_Text1].[language] =3D @.language
> Viel Erfolg,
> Gert-Jan
>
> david.ehrler@.zone3000.ch wrote:
icle_id]
IN
d] INNER
d] INNER
] INNER
anguage]

Friday, March 9, 2012

Problem Making Sql database Connection in Deployed Site

VWD 2005 Express. Visual Basic. Sql Server 2005. I am trying to establish a connection to a SQL database. The connection (and all other database reads and writes) work fine in debug and in "view in browser" from VWD. I am running the VWD on the same server that hosts the site. When on my server (Windows 2003 Server) under IIS, the connection attempt times out.

Below is the code that is failing (only on the server when deployed):

PrivateSharedSub OpenConn(ByVal cmdAs SqlCommand,ByVal SuccessAsBoolean)

Dim connAsNew SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings("GoodNews_IntranetConnectionString").ToString)

'The connection string resolves to ("Data Source=HQSERVER\HQSERVER;Initial Catalog=GoodNews_Intranet;Integrated Security=True"

Try

conn.Open()

cmd.Connection = conn

Success =True

Catch exAs Exception

Success =False

EndTry

EndSub

It would be great if you could post the error message that you are getting.

And in a hosted environment, it is advisable to protect your database by providing a username and password.

|||

That may be the ticket. The database does require windows authentication, so how may I make the connection (in vb code) providing a username and password? Perhaps when I am in debug, the sql calls use my windows login, however, when on the server, there is not password being passed?

|||

Please visitwww.connectionstrings.com to know the syntax for creating a connection string for your backend with user name and password.

If you think, this resolves your problem, please mark the post as "Answer". by this way we all know your issue is resolved

|||

Thank you. I found the answer on the page. I put the User Id and Password in the web.config file where the connection is defined. How can I ensure that this will not be readable when the web site is deployed?

|||

It won't be readable to a normal user, but for added security, if its not already in web.confing, then put it there. You can then use encryption to encrypt the connectionstring section (which is much easier than it sounds).

This might help:

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

|||

WEB.CONFIG file is a secure one. No one can read that file outside of your application. In other words, web.config can only be read by the pages within application.

every body uses the web.config to store connection strings and is safe so far.

read the following article to know more about web.config.

http://www.aspdev.org/articles/web.config/

also, please do not forget to mark my post as answer so that we will know for sure that your issue has been resolved.

Wednesday, March 7, 2012

problem installing SQL Server Express CTP April 2005

File Information

Verifying link...

hi,

How ever hard i tried to install "SQL Server Express CTP april 2005" i get errors. Earlier my system had previous version (beta 2) of the same. I removed and tried to install but cannot.

My system is already installed with MSDE 2000, Is it necessary to uninstall that ?

My another system is installed with SQL Server 2000 , i could also not able to install / rather i could not connect to SQL Express however tried.

could any one help.

thanks

Sad

There are a number of possibilities. Rather than speculate on what your problem might be, could you tell us:

What error do you get?
What OS and version are you installing on?
Is this machine connected to a domain? Is it in a workgroup?
Could you attach the setup logs?
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files

problem installing sql server express

help i'm having serious problems installing sql server express and quite at a loss.

i'm stuck at SQL Server Database Services and at Setting File Security. Can someone help? Seeing the SQL Server Database Services log i get this:

Action start 22:25:56: Write_sqlUserSecurity.D20239D7_E87C_40C9_9837_E70B8D4882C2.
<Func Name='LaunchFunction'>
Function=Write_sqlUserSecurity
<Func Name='SetCAContext'>
<EndFunc Name='SetCAContext' Return='T' GetLastError='203'>
Doing Action: Write_sqlUserSecurity
PerfTime Start: Write_sqlUserSecurity : Thu Dec 01 22:25:56 2005
<Func Name='Write_sqlUserSecurity'>
<Func Name='ScheduleActionX'>
<Func Name='SetCAContext'>
MSI (s) (44!E8) [22:25:56:417]: PROPERTY CHANGE: Adding Do_sqlUserSecurity.D20239D7_E87C_40C9_9837_E70B8D4882C2 property. Its value is '0 1 0 Setting User Security 50000 SQLServer2005SQLBrowserUser$ZSG03-1030 SeServiceLogonRight SQLServer2005MSSQLUser$ZSG03-1030$SQLEXPRESS SeServiceLogonRight SQLServer2005MSSQLUser$ZSG03-1030$SQLEXPRESS SeBatchLogonRight SQLServer2005MSSQLUser$ZSG03-1030$SQLEXPRESS SeAssignPrimaryTokenPrivilege SQLServer2005MSSQLUser$ZSG03-1030$SQLEXPRESS SeChangeNotifyPrivilege SQLServer2005MSSQLUser$ZSG03-1030$SQLEXPRESS SeIncreaseQuotaPrivilege '.
MSI (s) (44!E8) [22:25:56:417]: Doing action: Do_sqlUserSecurity.D20239D7_E87C_40C9_9837_E70B8D4882C2
<EndFunc Name='SetCAContext' Return='T' GetLastError='0'>
Action start 22:25:56: Do_sqlUserSecurity.D20239D7_E87C_40C9_9837_E70B8D4882C2.
MSI (s) (44!E8) [22:25:56:417]: PROPERTY CHANGE: Deleting Do_sqlUserSecurity.D20239D7_E87C_40C9_9837_E70B8D4882C2 property. Its current value is '0 1 0 Setting User Security 50000 SQLServer2005SQLBrowserUser$ZSG03-1030 SeServiceLogonRight SQLServer2005MSSQLUser$ZSG03-1030$SQLEXPRESS SeServiceLogonRight SQLServer2005MSSQLUser$ZSG03-1030$SQLEXPRESS SeBatchLogonRight SQLServer2005MSSQLUser$ZSG03-1030$SQLEXPRESS SeAssignPrimaryTokenPrivilege SQLServer2005MSSQLUser$ZSG03-1030$SQLEXPRESS SeChangeNotifyPrivilege SQLServer2005MSSQLUser$ZSG03-1030$SQLEXPRESS SeIncreaseQuotaPrivilege '.
Action ended 22:25:56: Do_sqlUserSecurity.D20239D7_E87C_40C9_9837_E70B8D4882C2. Return value 1.
<EndFunc Name='ScheduleActionX' Return='0' GetLastError='0'>
<EndFunc Name='Write_sqlUserSecurity' Return='0' GetLastError='0'>
PerfTime Stop: Write_sqlUserSecurity : Thu Dec 01 22:25:56 2005
<EndFunc Name='LaunchFunction' Return='0' GetLastError='0'>
MSI (s) (44:E4) [22:25:56:433]: Doing action: Write_sqlFileSDDL.D20239D7_E87C_40C9_9837_E70B8D4882C2
Action ended 22:25:56: Write_sqlUserSecurity.D20239D7_E87C_40C9_9837_E70B8D4882C2. Return value 1.
MSI (s) (44:DC) [22:25:56:448]: Invoking remote custom action. DLL: C:\WINDOWS\Installer\MSIED.tmp, Entrypoint: Write_sqlFileSDDL
Action start 22:25:56: Write_sqlFileSDDL.D20239D7_E87C_40C9_9837_E70B8D4882C2.
<Func Name='LaunchFunction'>
Function=Write_sqlFileSDDL
<Func Name='SetCAContext'>
<EndFunc Name='SetCAContext' Return='T' GetLastError='203'>
Doing Action: Write_sqlFileSDDL
PerfTime Start: Write_sqlFileSDDL : Thu Dec 01 22:25:56 2005

I'm having the same problem installing SQL 2005 Enterprise Edtion. Once it gets to the "Setting File Security...", it just sits there hung. The only way to kill it is using the Task Manager.

It also looked like it was hung during "Installing Local Goups", but after 30 minutes or so, it moved on.

Hopefully someone from Microsoft can help us out!!!

|||... I'm having the same problem with the developer edition :(|||PROBLEM SOLVED : (?) Well, I think. I still need to test, but at least the install finished without error. Yesterday, I started the install at 2:46 PM and just let it run. Almost 8 hours later at 10:33 PM it finished.

I only installed the SQL Server. I'll start the install for the services now and get back to you later when it finishes. It shouldn't take more than a few days! |||Good news, it only took 3.5 more hours to install all the services. Yes, it looked like it was hung there a few times, but I just let it go. Big Smile |||There is a workaround documented at
http://support.microsoft.com/?kbid=910070

-Jeffrey Baker
SQL Server Setup|||

Or simply disable your network temporarily if you are not installing from a network drive. Works like a charm !

Visit : http://sqljunkies.com/WebLog/simons/archive/2007/06/01/SQL_2005_install_hangs_on__Setting_File_Security_.aspx

SQL 2005 install hangs on "Setting File Security"

When doing an install of SQL 2005 you may encounter the install hanging on the "setting file security" stage.

This is due to th install trying to do some security resolution with domain controllers.

The easiest answer is to unplug the network cable (or disable the network interface), however if you are doing a remote install that may not be possible.

This KB discusses the issue http://support.microsoft.com/kb/910070/en-us and does provide hotfix which can be applied to the install so you don't encounter the problem

problem installing sql server express

help i'm having serious problems installing sql server express and quite at a loss.

i'm stuck at SQL Server Database Services and at Setting File Security. Can someone help? Seeing the SQL Server Database Services log i get this:

I'm having the same problem installing SQL 2005 Enterprise Edtion. Once it gets to the "Setting File Security...", it just sits there hung. The only way to kill it is using the Task Manager.

It also looked like it was hung during "Installing Local Goups", but after 30 minutes or so, it moved on.

Hopefully someone from Microsoft can help us out!!!

-Jeffrey Baker
SQL Server Setup|||

Or simply disable your network temporarily if you are not installing from a network drive. Works like a charm !

Visit : http://sqljunkies.com/WebLog/simons/archive/2007/06/01/SQL_2005_install_hangs_on__Setting_File_Security_.aspx

SQL 2005 install hangs on "Setting File Security"

When doing an install of SQL 2005 you may encounter the install hanging on the "setting file security" stage.

This is due to th install trying to do some security resolution with domain controllers.

The easiest answer is to unplug the network cable (or disable the network interface), however if you are doing a remote install that may not be possible.

This KB discusses the issue http://support.microsoft.com/kb/910070/en-us and does provide hotfix which can be applied to the install so you don't encounter the problem

PROBLEM INSTALLING SQL SERVER EXPRESS

Hi,

I successfully installed Visual Basic 2005 express edition and but the SQL Server component did not get installed.

12:37:11 AM Sunday, April 09, 2006: [Fail] ConfigSamplesDll_DoTasks:: [Fail] Config_SSE_INST_Install: SQL Express service install (failed). The process did not return a success value. ExitCode: 1282 Command: 'C:\Documents and Settings\Oluwaseyi Awoga\Local Settings\Temp\SQLEXPR32.exe -q /norebootchk /qn reboot=ReallySuppress addlocal=all SCCCHECKLEVEL=IncompatibleComponents:1 instancename=SQLEXPRESS'.

I keep getting this error. Can anybody help me? I have uninstalled and installed ALL versions of the .NET framework etc several times. Thanks

This is also the error signature. Thanks for your help.

Error Signature:
EventType : BEX P1 : setup.exe P2 : 2005.90.1399.0 P3 : 434f6403
P4 : msdtcprx.dll P5 : 2001.12.4414.258 P6 : 41109703 P7 : 0000a2c9
P8 : c0000409 P9 : 00000000

|||

This is the content of the C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files

Microsoft SQL Server 2005 Setup beginning at Sun Apr 09 01:46:18 2006
Process ID : 952
c:\e37376beb65a16277a8441b9\setup.exe Version: 2005.90.1399.0
Running: LoadResourcesAction at: 2006/3/9 1:46:17
Complete: LoadResourcesAction at: 2006/3/9 1:46:18, returned true
Running: ParseBootstrapOptionsAction at: 2006/3/9 1:46:18
Loaded DLL:c:\e37376beb65a16277a8441b9\xmlrw.dll Version:2.0.3604.0
Complete: ParseBootstrapOptionsAction at: 2006/3/9 1:46:18, returned true
Running: ValidateWinNTAction at: 2006/3/9 1:46:18
Complete: ValidateWinNTAction at: 2006/3/9 1:46:18, returned true
Running: ValidateMinOSAction at: 2006/3/9 1:46:18
Complete: ValidateMinOSAction at: 2006/3/9 1:46:18, returned true
Running: PerformSCCAction at: 2006/3/9 1:46:18
Complete: PerformSCCAction at: 2006/3/9 1:46:18, returned true
Running: ActivateLoggingAction at: 2006/3/9 1:46:18
Complete: ActivateLoggingAction at: 2006/3/9 1:46:18, returned true
Running: DetectPatchedBootstrapAction at: 2006/3/9 1:46:18
Complete: DetectPatchedBootstrapAction at: 2006/3/9 1:46:18, returned true
Action "LaunchPatchedBootstrapAction" will be skipped due to the following restrictions:
Condition "EventCondition: __STP_LaunchPatchedBootstrap__952" returned false.
Running: PerformSCCAction2 at: 2006/3/9 1:46:18
Loaded DLL:C:\WINDOWS\system32\msi.dll Version:3.1.4000.2435
Loaded DLL:C:\WINDOWS\system32\msi.dll Version:3.1.4000.2435
Complete: PerformSCCAction2 at: 2006/3/9 1:46:18, returned true
Running: PerformDotNetCheck at: 2006/3/9 1:46:18
Complete: PerformDotNetCheck at: 2006/3/9 1:46:18, returned true
Running: ComponentUpdateAction at: 2006/3/9 1:46:18
Complete: ComponentUpdateAction at: 2006/3/9 1:46:23, returned true
Running: DetectLocalBootstrapAction at: 2006/3/9 1:46:23
Complete: DetectLocalBootstrapAction at: 2006/3/9 1:46:23, returned true
Running: LaunchLocalBootstrapAction at: 2006/3/9 1:46:23
Error: Action "LaunchLocalBootstrapAction" threw an exception during execution. Error information reported during run:
"c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\setup.exe" finished and returned: 1282
Aborting queue processing as nested installer has completed
Message pump returning: 1282

Thanks!!

|||

I'm going to move this to the SQL Setup forum.

- Mike

|||

I don't believe 1282 is a Setup error code; it's probably a Windows error code. 1282 translates to stack buffer overflow. We did fix one or two such issues a long time back. If the version of Express you're trying to install is pre-RTM then please download the RTM version or the remastered Express SP1 which should be available soon, and try again. If you're already trying with RTM then I suspect we're going to need to see the complete SQL Install logs to debug your problem.

Paul

Problem installing SQL Server 2005 express, In windows 2000

I have downloaded SQL Server 2005 express from microsoft's site and tried to install in windows 2000 service pack 4 but having an unexpected error. The screenshot and log file is attached. Please suggest.

The error log is as shown:

Microsoft SQL Server 2005 Setup beginning at Fri May 05 21:36:51 2006
Process ID : 1008
e:\469a4a9ba4bfdc9d2db501289fb676\setup.exe Version: 2005.90.2047.0
Running: LoadResourcesAction at: 2006/4/5 21:34:50
Complete: LoadResourcesAction at: 2006/4/5 21:34:50, returned true
Running: ParseBootstrapOptionsAction at: 2006/4/5 21:34:50
Loaded DLL:e:\469a4a9ba4bfdc9d2db501289fb676\xmlrw.dll Version:2.0.3609.0
Complete: ParseBootstrapOptionsAction at: 2006/4/5 21:36:51, returned false
Error: Action "ParseBootstrapOptionsAction" failed during execution. Error information reported during run:
Could not parse command line due to datastore exception.
Source File Name: utillib\persisthelpers.cpp
Compiler Timestamp: Wed Oct 26 16:38:20 2005
Function Name: writeEncryptedString
Source Line Number: 124
-
writeEncryptedString() failed
Source File Name: utillib\persisthelpers.cpp
Compiler Timestamp: Wed Oct 26 16:38:20 2005
Function Name: writeEncryptedString
Source Line Number: 123
-
Error Code: 0x800706b5 (1717)
Windows Error Text: The interface is unknown.

Source File Name: cryptohelper\cryptsameusersamemachine.cpp
Compiler Timestamp: Wed Oct 26 16:37:25 2005
Function Name: sqls::CryptSameUserSameMachine::ProtectData
Source Line Number: 50

1717
Could not skip Component update due to datastore exception.
Source File Name: datastore\cachedpropertycollection.cpp
Compiler Timestamp: Wed Oct 26 16:37:20 2005
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
-
Failed to find property "InstallMediaPath" {"SetupBootstrapOptionsScope", "", "1008"} in cache
Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Wed Oct 26 16:37:21 2005
Function Name: SetupBootstrapOptionsScope.InstallMediaPath
Source Line Number: 44
-
No collector registered for scope: "SetupBootstrapOptionsScope"
Running: ValidateWinNTAction at: 2006/4/5 21:36:51
Complete: ValidateWinNTAction at: 2006/4/5 21:36:51, returned true
Running: ValidateMinOSAction at: 2006/4/5 21:36:51
Complete: ValidateMinOSAction at: 2006/4/5 21:36:51, returned true
Running: PerformSCCAction at: 2006/4/5 21:36:51
Complete: PerformSCCAction at: 2006/4/5 21:36:51, returned true
Running: ActivateLoggingAction at: 2006/4/5 21:36:51
Error: Action "ActivateLoggingAction" threw an exception during execution. Error information reported during run:
Datastore exception while trying to write logging properties.
Source File Name: datastore\cachedpropertycollection.cpp
Compiler Timestamp: Wed Oct 26 16:37:20 2005
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
-
Failed to find property "primaryLogFiles" {"SetupStateScope", "", ""} in cache
Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Wed Oct 26 16:37:21 2005
Function Name: SetupStateScope.primaryLogFiles
Source Line Number: 44
-
No collector registered for scope: "SetupStateScope"
02AFCFC0Unable to proceed with setup, there was a command line parsing error. : 2
Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.

Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Wed Oct 26 16:37:21 2005
Function Name: SetupBootstrapOptionsScope.InstallMediaPath
Source Line Number: 44

Class not registered.
Failed to create CAB file due to datastore exception
Source File Name: datastore\cachedpropertycollection.cpp
Compiler Timestamp: Wed Oct 26 16:37:20 2005
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
-
Failed to find property "HostSetup" {"SetupBootstrapOptionsScope", "", "1008"} in cache
Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Wed Oct 26 16:37:21 2005
Function Name: SetupBootstrapOptionsScope.HostSetup
Source Line Number: 44
-
No collector registered for scope: "SetupBootstrapOptionsScope"
Message pump returning: 2

I had what looks to be the same problem trying to install on three different Windows XP Pro systems. They all had the same problem which was caused by not having the AppData key in \Microsoft\Windows\CurrentVersion\Explorer\User Shell Folders. Here is the text posted by Arron Rouse on Developers dex.
After a good amount of delving with RegMon, I found out why it was not
installing on my customer's build: there was a missing Registry key.

HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\User
Shell Folders\AppData

When a user is created on a system, the AppData key is copied from the
..Default area of the registry:

HKEY_USERS\.DEFAULT\Software\Microsoft\Windows\CurrentVersion\Explorer\User
Shell Folders\AppData

It seems the key had been messed up in my customer's build. Both should be a
REG_EXPAND_SZ and both should be set to %USERPROFILE%\Application Data

Note that if the key is missing on your system, you might have problems when
you put it back in as many programs seem to failover to using the Local
AppData key if it's missing. You might have to set the AppData key to
%USERPROFILE%\Local Settings\Application Data

Problem installing SQL Server 2005 express, In windows 2000

The error log is as shown:

Source File Name: cryptohelper\cryptsameusersamemachine.cpp
Compiler Timestamp: Wed Oct 26 16:37:25 2005
Function Name: sqls::CryptSameUserSameMachine::ProtectData
Source Line Number: 50

Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Wed Oct 26 16:37:21 2005
Function Name: SetupBootstrapOptionsScope.InstallMediaPath
Source Line Number: 44

Problem installing SQL Server 2005 Express with Advance Services CTP

Hi,

I was unable to install the CTP version of SS Express Edition SP1 with Advance Services. The installation failed with the following error message:

TITLE: Microsoft SQL Server 2005 Setup

SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client][SQL Server]Login failed for user 'sa'. Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.

However, I was able to install and run the standard CTP version of SS Express Edition SP1 without any problems, even though the above error message indicated I may have login problem. First let me confess that my computer does not have IIS installed, which as I understand is only needed for running the Report Services. Is it necessary for IIS to be up and running while installing SSEE with Advance Services?

The main reason I want to install SSEE with Advance Services is to use the full text search capability. I do not need the Report Services, and was hoping there is an option to turn it off and not require IIS. Is this possible?

Mike

Hi Mike,

You do not need to have IIS installed or running to install Express Advanced as long as you don't need Reporting Services. As far as the error you're getting, we'd really need to check for additional informaiton in the setup log. Could you check that out and get back to the thread with the info from the log?

Regards,

Mike Wachal
SQL Express team

-
Check out my tips for getting your answer faster and how to ask a good question: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=307712&SiteID=1

|||

Hi Mike,

I am glad to hear that IIS is not required for SQLExpress Advanced installation. The error I got is as follows taken from the summary log file.

Machine : WS2
Product : Microsoft SQL Server 2005
Product Version : 9.1.2040.00
Install : Failed
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0002_WS2_SQL.log
Last Action : InstallFinalize
Error String : SQL Server Setup could not connect to the database service for server configuration. The error was: {Microsoft}{SQL Native Client}{SQL Server}Login failed for user 'sa'. Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.
Error Number : 29515

Background information: (OS: Windows XP SP2)

1. Logged in as user with local administrative priviliges.

2. Installed SQL Express RTM a while back, and was able to login to instance and use databases.

3. Attempted to install SQLExpress Advanced CTP without uninstalling SQLExpress RTM. This process is suppose to upgrade the existing installation.

4. *** Installation fails and the sql server setup installation rolls back. *** The previous installation (SQLExpress RTM) is automatically restored, and I am able to login to the sql server.

5. l then try to install SQLExpress CTP. This works perfectly. Note I did not make any changes between steps 4 and 5 (e.g. no reboot, etc.).

Looking through the log files it looks like the SQLExpress Advanced is trying to make an ODBC connection and failing. Why is it trying to use ODBC?

Anyway there is a lot of information in the logs that I do not understand, so it would be better if I could send them to you. (All the log files are in a 1.3M cab file) Please advise.

Thanks,

Mike

|||I am having the same error message also. I previously installed Visual Studio 2005 (not express). Could this have changed the sa password?|||

Hi, I've got the same problem - any ideas?

TITLE: Microsoft SQL Server 2005 Setup

For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=setup.rll&EvtID=29515&EvtType=lib%5codbc_connection.cpp%40Do_sqlScript%40OdbcConnection%3a%3aconnect%40connect%40x4818

BUTTONS:

&Retry
Cancel

|||I have the same error during setup. I was upgrading a named instance of SSEE 2005 to SSEE w/ Advanced Services.

I used Windows Auth for the install; my windows account is a local admin on the server in question (Win2k Server) and my account has the sysadmin role in SQL Server.

I also tried it using SQL Server Auth with the SA account. That immediately showed the message:

"SQL Server Setup cannot upgrade the specified instance by using SQL Server credentials. You must use Windows Authentication credentials for the upgrade."

So, I find it strange that the setup fails with the message:

"SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client][SQL Server]Login failed for user 'sa'. Refer to server error logs and setup logs for more information."
(The Error Number in the log summary is 29515)

It says the login failed for user 'sa' even though I used Windows Authentication.

Btw, I used the download posted here: http://msdn.microsoft.com/vstudio/express/sql/download/ Is that still a CTP?
|||More info from the error log:

SQL_ERROR (-1) in OdbcConnection::connect
sqlstate=28000, level=-1, state=-1, native_error=18456, msg=[Microsoft][SQL Native Client][SQL Server]Login failed for user 'sa'.

Error Code: 0x80074818 (18456)
Windows Error Text: Source File Name: lib\odbc_connection.cpp
Compiler Timestamp: Wed Oct 26 16:37:41 2005
Function Name: OdbcConnection::connect@.connect
Source Line Number: 148

- Context --

Connecting to SQL Server
ExecuteSqlCommands
Originial error was 80074818 (18456)
ipt
SqlScriptHlpr

Error Code: 18456
MSI (s) (34!D4) [16:38:57:313]: Product: Microsoft SQL Server 2005 -- Error 29515. SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client][SQL Server]Login failed for user 'sa'. Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.

Error 29515. SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client][SQL Server]Login failed for user 'sa'. Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.
<Failure Type='Fatal' Error='18456'>
<EndFunc Name='LaunchFunction' Return='18456' GetLastError='203'>
MSI (s) (34:C8) [16:38:57:360]: User policy value 'DisableRollback' is 0
MSI (s) (34:C8) [16:38:57:360]: Machine policy value 'DisableRollback' is 0
Action ended 16:38:57: InstallFinalize. Return value 3.
|||

Seems to be an issue that happens during upgrade.

In order to correctly upgrade from Express Edition to Express Edition with Advanced Services, follow the instructions in the SQL Express blog at: http://blogs.msdn.com/sqlexpress/archive/2006/04/20/UpgradeToAdvanced.aspx

If you've already tried to upgrade and received the error "Login failed for user 'sa'" then you will need to follow the instructions in the SQL Express blog at: http://blogs.msdn.com/sqlexpress/archive/2006/04/20/580312.aspx

Regards,

Mike Wachal
SQL Express team

-
Please mark your thread as Answered when you get your solution.

|||Brilliant!
I ran into the same problem yesterday. Will try to use the blog posts to solve my problem. :)

Kaisa
|||The new version of SQLEXP_ADV worked just fine, I was using an earlier version saved on my CD's from Apr, but I just don't understand why these things just get so hard to fine. Great Job!!!! Keep up the hard work....

Problem installing SQL Server 2005 Express Edition with Advanced Services SP2

Don't know if this is the appropriate forum...

I have encountered a showstopper problem during installation. I have installed SSEE on a fresh XP, all the checks but memory requirements passed. In the final stage of the install, during the "real work", the Client Component installation failed due to missing ASP.NET state service (? spelling). After the failure the installation continued, but marked both the db engine and the management studio failed. Despite this, management studio was installed and later I have removed it with the control panel applet.

I have found a service (executable: aspnet_state.exe), started it and retried the installation. It failed again so I have removed everything installed except the VSS writer and started it again. This time the installation completed (and finally got BIDS).

Is it enough to start this ASP service manually for a painless install? I don't want to play this "on the field" ever...

I'd need to see the install log from a failed attempt to really understand the problem. This is the first time I've heard mention of the asp.net state service, so this doesn't seem like a common issue. We should get to the bottom of what is really happening before you start trying to start random services on your customers computers.

Mike

|||Is earlier install logs kept? There were two attempts after it, one successfull and one uninstall. At the end of the first failed attempt the installer sent an error report on a form looked like the standard error reporting form - had the installer an unhandled exception or was it my installation feedback?|||

Mike,

I hate to post in someone elses thread, but this sounds like the exact same issue I am having. Here is the ERRORLOG:

2007-04-30 14:15:39.88 Server Microsoft SQL Server 2005 - 9.00.2050.00 (Intel X86)
Feb 13 2007 23:02:48
Copyright (c) 1988-2005 Microsoft Corporation
Express Edition with Advanced Services on Windows NT 5.1 (Build 2600: Service Pack 2)

2007-04-30 14:15:39.88 Server (c) 2005 Microsoft Corporation.
2007-04-30 14:15:39.88 Server All rights reserved.
2007-04-30 14:15:39.88 Server Server process ID is 2088.
2007-04-30 14:15:39.88 Server Logging SQL Server messages in file 'c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.
2007-04-30 14:15:39.88 Server This instance of SQL Server last reported using a process ID of 3108 at 4/30/2007 2:08:46 PM (local) 4/30/2007 6:08:46 PM (UTC). This is an informational message only; no user action is required.
2007-04-30 14:15:39.88 Server Registry startup parameters:
2007-04-30 14:15:39.88 Server -d c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf
2007-04-30 14:15:39.88 Server -e c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG
2007-04-30 14:15:39.88 Server -l c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
2007-04-30 14:15:39.93 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2007-04-30 14:15:39.93 Server Detected 1 CPUs. This is an informational message; no user action is required.
2007-04-30 14:15:40.10 Server Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.
2007-04-30 14:15:40.19 Server Could not query the FIPS compliance mode flag from registry. Error 2(The system cannot find the file specified.).
2007-04-30 14:15:40.26 Server Database mirroring has been enabled on this instance of SQL Server.
2007-04-30 14:15:40.27 spid5s Starting up database 'master'.
2007-04-30 14:15:40.30 spid5s Error: 5118, Severity: 16, State: 1.
2007-04-30 14:15:40.30 spid5s The file "c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf" is compressed but does not reside in a read-only database or filegroup. The file must be decompressed.
2007-04-30 14:15:40.30 spid5s Error: 5118, Severity: 16, State: 1.
2007-04-30 14:15:40.30 spid5s The file "c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf" is compressed but does not reside in a read-only database or filegroup. The file must be decompressed.
2007-04-30 14:15:40.32 spid5s Error: 5118, Severity: 16, State: 1.
2007-04-30 14:15:40.32 spid5s The file "c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf" is compressed but does not reside in a read-only database or filegroup. The file must be decompressed.
2007-04-30 14:15:40.32 spid5s Error: 5118, Severity: 16, State: 1.
2007-04-30 14:15:40.32 spid5s The file "c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf" is compressed but does not reside in a read-only database or filegroup. The file must be decompressed.

I went into the Computer Management console and tried to restart the SQLEXPRESS service (SQL Server Active Directory Helper also) and it gives me "server-specific error code 3417"

Thanks in advance,

Nick

|||According to the end of your log your problem is that your database is in a compressed folder (usually blue letters in Explorer). I think you should uncompress the c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA folder (right-click on the folder, Properties, Special button and uncheck). Or mark it as a read-only database but I don't think you want to do that.|||

All your logs should be sitting in C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files. They are number sequentially and you can also use the create date to identify the correct log. The standard error reporting dialog does not collect personal informaiton, nor does it collect the install logs, so I can access anything related to that.

MIke

|||

Regarding Nick's issue - We don't support installing to compressed folders so you'll need to uncompress before doing any install/upgrade.

Mike

|||There is no "Special" button|||

"Unfortunatelly" I have a hungarian XP so the button label re-translation failed. It is the button on the right side of attributes read only and hidden.

Here is an official description:

To set the compression state of a folder or file

In My Computer or Windows Explorer, right-click the file or folder to compress or decompress.

Click Properties to display the Properties dialog box.

On the General tab, click Advanced.

In the Advanced Attributes dialog box, select or clear the Compress contents to save disk space check box and then click OK.

In the Properties dialog box, click OK.

If the compression state was altered for a folder, in the Confirm Attribute Changes dialog box, select whether to make the compression apply only to the selected folder or to the selected folder and all its files and subfolders. Click OK when done.

Note Windows XP Professional can compress closed paging files. However, when you restart Windows XP Professional, the paging files revert to an uncompressed state. For information about paging files, see the topics on virtual memory in Windows XP Professional Help.

You can set Windows Explorer to display alternate colors for compressed files and folders by using the following procedure:

To display alternate colors for compressed files and folders

In My Computer or Windows Explorer, click the Tools menu, and then click Folder Options.

On the View tab, select the Show encrypted or compressed NTFS files in color check box.

Click OK to return to Windows Explorer or My Computer.

|||

I was having a similar problem, only that for me I could not restart the service after it had stopprd.

Setting permissions on the ...sql server\MSSQL1\data folder sorted me out.

I granted full control on the folder to the machine\users group.

Problem installing SQL Server 2005 Express Edition with Advanced Services SP2

Don't know if this is the appropriate forum...

Is it enough to start this ASP service manually for a painless install? I don't want to play this "on the field" ever...

Mike

Mike,

I hate to post in someone elses thread, but this sounds like the exact same issue I am having. Here is the ERRORLOG:

I went into the Computer Management console and tried to restart the SQLEXPRESS service (SQL Server Active Directory Helper also) and it gives me "server-specific error code 3417"

Thanks in advance,

Nick

MIke

|||

Regarding Nick's issue - We don't support installing to compressed folders so you'll need to uncompress before doing any install/upgrade.

Mike

|||There is no "Special" button|||

"Unfortunatelly" I have a hungarian XP so the button label re-translation failed. It is the button on the right side of attributes read only and hidden.

Here is an official description:

To set the compression state of a folder or file

In My Computer or Windows Explorer, right-click the file or folder to compress or decompress.

Click Properties to display the Properties dialog box.

On the General tab, click Advanced.

In the Advanced Attributes dialog box, select or clear the Compress contents to save disk space check box and then click OK.

In the Properties dialog box, click OK.

You can set Windows Explorer to display alternate colors for compressed files and folders by using the following procedure:

To display alternate colors for compressed files and folders

In My Computer or Windows Explorer, click the Tools menu, and then click Folder Options.

On the View tab, select the Show encrypted or compressed NTFS files in color check box.

Click OK to return to Windows Explorer or My Computer.

|||

I was having a similar problem, only that for me I could not restart the service after it had stopprd.

Setting permissions on the ...sql server\MSSQL1\data folder sorted me out.

I granted full control on the folder to the machine\users group.

Problem installing SQL Server 2005 Express Edition

I have downloaded a free set of SQL Server 2005 Express edition. This set up has been installed successfully on my machine but it is showing me following links.

SQL Server Instance=SQLExpress

User Id=sa

Password=admin12

Start --> Microsoft Sql Server 2005 -->Configuration Tools --->SQL Server Configuration Manager

--->SQL Server Eroor and Usage Reporting

---->SQL Server Surface Area Configuration

But I don't find any option to start SQL Server 2005 express edition. Please help me out how to start SQL Server 2005 express edition?

dineshpatil:
But I don't find any option to start SQL Server 2005 express edition. Please help me out how to start SQL Server 2005 express edition?

You can use the SQL Server Surface area configuration to start/stop services like your SQL instance.

If you want a GUI interface then you need to install SQL Server Management Studio.

|||

Dear Jimmy,

Thanks for your reply. I have started SQL Server instance service. Is SQL Server Management Studio is free?
If it is free, Please provide me URL path from where I can download?

Is there any other way with which I can run or access Microsoft SQL Server 2005 Express Edition?

|||

http://msdn2.microsoft.com/nl-nl/express/bb410792(en-us).aspx

|||

dineshpatil:
Thanks for your reply. I have started SQL Server instance service. Is SQL Server Management Studio is free?
If it is free, Please provide me URL path from where I can download?

Yes it is free and you can download it here

http://www.microsoft.com/downloads/details.aspx?FamilyId=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en

dineshpatil:
Is there any other way with which I can run or access Microsoft SQL Server 2005 Express Edition?

Your Express database is already installed so you can use it right away. You can either connect from the VS IDE, but if you want a GUI to the database then you need to use the SQL Management tool another 3rd party tool or rely on Visual Studio's server explorer.

|||

Thanks guys. Now it is working fine.

Friday, March 30, 2012

Problem Running Sql Server 2005 Express on Vista

Wednesday, March 28, 2012

Problem returning data

Problem Restoring Database

Problem Restoring Database

Wednesday, March 21, 2012

Problem opening SSMS Express

Tuesday, March 20, 2012

Problem on collation on SQL Server Express with Windows Mobile 5.0

Problem on collation on SQL Server Express with Windows Mobile 5.0

problem of uploading asp.net website on web server

Server Error in '/' Application.

this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections

Monday, March 12, 2012

Problem mit Stored Procedure

Friday, March 9, 2012

Problem Making Sql database Connection in Deployed Site

Wednesday, March 7, 2012

problem installing SQL Server Express CTP April 2005

problem installing sql server express

SQL 2005 install hangs on "Setting File Security"

problem installing sql server express

SQL 2005 install hangs on "Setting File Security"

PROBLEM INSTALLING SQL SERVER EXPRESS

Problem installing SQL Server 2005 express, In windows 2000

Problem installing SQL Server 2005 express, In windows 2000

Problem installing SQL Server 2005 Express with Advance Services CTP

Problem installing SQL Server 2005 Express Edition with Advanced Services SP2

To set the compression state of a folder or file

To display alternate colors for compressed files and folders

Problem installing SQL Server 2005 Express Edition with Advanced Services SP2

To set the compression state of a folder or file

To display alternate colors for compressed files and folders

Problem installing SQL Server 2005 Express Edition

xp cmdshell

Blog Archive

About Me

Friday, March 30, 2012

Wednesday, March 28, 2012

Wednesday, March 21, 2012

Tuesday, March 20, 2012

Server Error in '/' Application.

this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections

Monday, March 12, 2012

Friday, March 9, 2012

Wednesday, March 7, 2012

SQL 2005 install hangs on &quot;Setting File Security&quot;

SQL 2005 install hangs on &quot;Setting File Security&quot;

To set the compression state of a folder or file

To display alternate colors for compressed files and folders

To set the compression state of a folder or file

To display alternate colors for compressed files and folders

Blog Archive

About Me

SQL 2005 install hangs on "Setting File Security"

SQL 2005 install hangs on "Setting File Security"