Instance specified not valid

Hi,

I'm trying to install MSDE SP3 which I downloaded from MS at http://www.asp.net/msde/.
Following the instructions as best I can I unzipped the file into a Folder now called MSDE located on C: I then went to a command prompt and typed in the command given to start the install:

setup SAPWD=testsite SecurityMode=SQL

Hit enter and the installer started up and ran for a few secs and then came back with

The Instance named specified is invalid

There was no mention of including an instance name or the format for it.

Suggestions please?

Also, if I want to completly uninstall MSDE if I need to how would I do it?

Thanks,
BobWell, I had this message come up if I tried to run setup for the instance that was already on the system.

I used this setup to install msde on my machine.

setup instancename="netsdk" sapwd="your password for sa" securitymode=sql

Reason for using instance name netsdk was that it seems that SDK kit needs this instance to install pubs and nwind database.

After executing this i did not get any error messages but when I started service manager I could not see any servers listed. It took me solid two hours to come up with idea to look into error log and there it was.

2004-03-09 11:57:44.50 server Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Desktop Engine on Windows NT 5.1 (Build 2600: Service Pack 1)

2004-03-09 11:57:44.50 server Copyright (C) 1988-2002 Microsoft Corporation.
2004-03-09 11:57:44.50 server All rights reserved.
2004-03-09 11:57:44.50 server Server Process ID is 3456.
2004-03-09 11:57:44.50 server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL$NETSDK\LOG\ERRORLOG'.
2004-03-09 11:57:44.52 server SQL Server is starting at priority class 'normal'(2 CPUs detected).
2004-03-09 11:57:44.63 server SQL Server configured for thread mode processing.
2004-03-09 11:57:44.63 server Using dynamic lock allocation. [500] Lock Blocks, [1000] Lock Owner Blocks.
2004-03-09 11:57:44.63 spid2 Warning ******************
2004-03-09 11:57:44.63 spid2 SQL Server started in single user mode. Updates allowed to system catalogs.
2004-03-09 11:57:44.63 spid2 Starting up database 'master'.
2004-03-09 11:57:44.98 spid5 Starting up database 'model'.
2004-03-09 11:57:44.98 server Using 'SSNETLIB.DLL' version '8.0.766'.
2004-03-09 11:57:45.03 spid2 Server name is 'PC0491-EPITKA\NETSDK'.
2004-03-09 11:57:45.03 spid2 Skipping startup of clean database id 5
2004-03-09 11:57:45.03 spid2 Skipping startup of clean database id 6
2004-03-09 11:57:45.03 spid2 Starting up database 'msdb'.
2004-03-09 11:57:45.17 server SQL server listening on Shared Memory.
2004-03-09 11:57:45.17 server SQL Server is ready for client connections
2004-03-09 11:57:45.38 spid5 Clearing tempdb database.
2004-03-09 11:57:46.12 spid5 Starting up database 'tempdb'.
2004-03-09 11:57:46.20 spid2 Recovery complete.
2004-03-09 11:57:46.20 spid2 SQL global counter collection task is created.
2004-03-09 11:57:46.22 spid2 Warning: override, autoexec procedures skipped.
2004-03-09 11:57:56.94 spid51 Error: 15457, Severity: 0, State: 1
2004-03-09 11:57:56.94 spid51 Configuration option 'allow updates' changed from 0 to 1. Run the RECONFIGURE statement to install..
2004-03-09 11:57:57.08 spid51 Error: 15457, Severity: 0, State: 1
2004-03-09 11:57:57.08 spid51 Configuration option 'allow updates' changed from 1 to 0. Run the RECONFIGURE statement to install..
2004-03-09 11:57:57.34 spid2 SQL Server is terminating due to 'stop' request from Service Control Manager.

There is a line that says servername, I typed it in and I was able to start service. Log should be under c:\program files\microsoft sql server\mssql${your instance name}\log.

I am very new to windows world since I worked on Unix platform for past six years, so for you gurus out there this migth be something that does not need to be explained. Anyway I hope this helps.sql

INstalling sql2005 Express

I have this report while installing this product.
Something about ASP.NET. O yes, it is Vista Business.
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. (Success)
Messages
* Operating System Service Pack Level Requirement.
* Check Passed
- SQL Server Edition Operating System Compatibility (Success)
Messages
* SQL Server Edition Operating System Compatibility
* Check Passed
- Minimum Hardware Requirement (Success)
Messages
* Minimum Hardware Requirement
* Check Passed
- IIS Feature Requirement (Success)
Messages
* IIS Feature Requirement
* Check Passed
- Pending Reboot Requirement (Success)
Messages
* Pending Reboot Requirement
* Check Passed
- Performance Monitor Counter Requirement (Success)
Messages
* Performance Monitor Counter 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 (Warning)
Messages
* ASP.Net Version Registration Requirement
* Failed to find the ASP.Net Version Registration with Microsoft Internet
Information Services (IIS).
- Minimum MDAC Version Requirement (Success)
Messages
* Minimum MDAC Version Requirement
* Check Passed
- Edition Change Check (Success)
Messages
* Edition Change Check
* Check Passed
ThanksMark,
You will either need to enable ASP on II6 (Disabled by default) or register
it so you can then enable it, to register refer
http://msdn2.microsoft.com/en-us/library/k6h9cz8h(VS.80).aspx
to enable,
Open IIS Manager > Select Web Service Extensions, select the appropiate
service and "Allow" it..
Cheers
Matt
"Markgoldin" wrote:
> I have this report while installing this product.
> Something about ASP.NET. O yes, it is Vista Business.
> 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. (Success)
> Messages
> * Operating System Service Pack Level Requirement.
> * Check Passed
>
> - SQL Server Edition Operating System Compatibility (Success)
> Messages
> * SQL Server Edition Operating System Compatibility
> * Check Passed
>
> - Minimum Hardware Requirement (Success)
> Messages
> * Minimum Hardware Requirement
> * Check Passed
>
> - IIS Feature Requirement (Success)
> Messages
> * IIS Feature Requirement
> * Check Passed
>
> - Pending Reboot Requirement (Success)
> Messages
> * Pending Reboot Requirement
> * Check Passed
>
> - Performance Monitor Counter Requirement (Success)
> Messages
> * Performance Monitor Counter 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 (Warning)
> Messages
> * ASP.Net Version Registration Requirement
> * Failed to find the ASP.Net Version Registration with Microsoft Internet
> Information Services (IIS).
>
> - Minimum MDAC Version Requirement (Success)
> Messages
> * Minimum MDAC Version Requirement
> * Check Passed
>
> - Edition Change Check (Success)
> Messages
> * Edition Change Check
> * Check Passed
>
> Thanks
>|||While I am using Vista that I dont have right now but I am opening I IS
Manager on my XP box
and I dont see Web Service Extensions. Can you please give me more details?
"Aussie Matt" <AussieMatt@.discussions.microsoft.com> wrote in message
news:0EDEC0DE-B6FE-4F75-9C77-1BC63068D9D7@.microsoft.com...
> Mark,
> You will either need to enable ASP on II6 (Disabled by default) or
> register
> it so you can then enable it, to register refer
> http://msdn2.microsoft.com/en-us/library/k6h9cz8h(VS.80).aspx
> to enable,
> Open IIS Manager > Select Web Service Extensions, select the appropiate
> service and "Allow" it..
> Cheers
> Matt
>
>
> "Markgoldin" wrote:
>> I have this report while installing this product.
>> Something about ASP.NET. O yes, it is Vista Business.
>> 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. (Success)
>> Messages
>> * Operating System Service Pack Level Requirement.
>> * Check Passed
>>
>> - SQL Server Edition Operating System Compatibility (Success)
>> Messages
>> * SQL Server Edition Operating System Compatibility
>> * Check Passed
>>
>> - Minimum Hardware Requirement (Success)
>> Messages
>> * Minimum Hardware Requirement
>> * Check Passed
>>
>> - IIS Feature Requirement (Success)
>> Messages
>> * IIS Feature Requirement
>> * Check Passed
>>
>> - Pending Reboot Requirement (Success)
>> Messages
>> * Pending Reboot Requirement
>> * Check Passed
>>
>> - Performance Monitor Counter Requirement (Success)
>> Messages
>> * Performance Monitor Counter 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 (Warning)
>> Messages
>> * ASP.Net Version Registration Requirement
>> * Failed to find the ASP.Net Version Registration with Microsoft
>> Internet
>> Information Services (IIS).
>>
>> - Minimum MDAC Version Requirement (Success)
>> Messages
>> * Minimum MDAC Version Requirement
>> * Check Passed
>>
>> - Edition Change Check (Success)
>> Messages
>> * Edition Change Check
>> * Check Passed
>>
>> Thanks|||Hi Mark,
What version of IIS are you running ?
...Matt
"Mark Goldin" wrote:
> While I am using Vista that I dont have right now but I am opening I IS
> Manager on my XP box
> and I dont see Web Service Extensions. Can you please give me more details?
> "Aussie Matt" <AussieMatt@.discussions.microsoft.com> wrote in message
> news:0EDEC0DE-B6FE-4F75-9C77-1BC63068D9D7@.microsoft.com...
> > Mark,
> > You will either need to enable ASP on II6 (Disabled by default) or
> > register
> > it so you can then enable it, to register refer
> >
> > http://msdn2.microsoft.com/en-us/library/k6h9cz8h(VS.80).aspx
> >
> > to enable,
> > Open IIS Manager > Select Web Service Extensions, select the appropiate
> > service and "Allow" it..
> >
> > Cheers
> >
> > Matt
> >
> >
> >
> >
> >
> > "Markgoldin" wrote:
> >
> >> I have this report while installing this product.
> >> Something about ASP.NET. O yes, it is Vista Business.
> >>
> >> 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. (Success)
> >> Messages
> >> * Operating System Service Pack Level Requirement.
> >>
> >> * Check Passed
> >>
> >>
> >> - SQL Server Edition Operating System Compatibility (Success)
> >> Messages
> >> * SQL Server Edition Operating System Compatibility
> >>
> >> * Check Passed
> >>
> >>
> >> - Minimum Hardware Requirement (Success)
> >> Messages
> >> * Minimum Hardware Requirement
> >>
> >> * Check Passed
> >>
> >>
> >> - IIS Feature Requirement (Success)
> >> Messages
> >> * IIS Feature Requirement
> >>
> >> * Check Passed
> >>
> >>
> >> - Pending Reboot Requirement (Success)
> >> Messages
> >> * Pending Reboot Requirement
> >>
> >> * Check Passed
> >>
> >>
> >> - Performance Monitor Counter Requirement (Success)
> >> Messages
> >> * Performance Monitor Counter 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 (Warning)
> >> Messages
> >> * ASP.Net Version Registration Requirement
> >>
> >> * Failed to find the ASP.Net Version Registration with Microsoft
> >> Internet
> >> Information Services (IIS).
> >>
> >>
> >> - Minimum MDAC Version Requirement (Success)
> >> Messages
> >> * Minimum MDAC Version Requirement
> >>
> >> * Check Passed
> >>
> >>
> >> - Edition Change Check (Success)
> >> Messages
> >> * Edition Change Check
> >>
> >> * Check Passed
> >>
> >>
> >>
> >> Thanks
> >>
>
>|||Well, on Vista it is 7. On Xp whatever comes with it.
"Aussie Matt" <AussieMatt@.discussions.microsoft.com> wrote in message
news:2F90EE6E-9D66-4671-8A94-9D39280B0F86@.microsoft.com...
> Hi Mark,
> What version of IIS are you running ?
> ...Matt
> "Mark Goldin" wrote:
>> While I am using Vista that I dont have right now but I am opening I IS
>> Manager on my XP box
>> and I dont see Web Service Extensions. Can you please give me more
>> details?
>> "Aussie Matt" <AussieMatt@.discussions.microsoft.com> wrote in message
>> news:0EDEC0DE-B6FE-4F75-9C77-1BC63068D9D7@.microsoft.com...
>> > Mark,
>> > You will either need to enable ASP on II6 (Disabled by default) or
>> > register
>> > it so you can then enable it, to register refer
>> >
>> > http://msdn2.microsoft.com/en-us/library/k6h9cz8h(VS.80).aspx
>> >
>> > to enable,
>> > Open IIS Manager > Select Web Service Extensions, select the appropiate
>> > service and "Allow" it..
>> >
>> > Cheers
>> >
>> > Matt
>> >
>> >
>> >
>> >
>> >
>> > "Markgoldin" wrote:
>> >
>> >> I have this report while installing this product.
>> >> Something about ASP.NET. O yes, it is Vista Business.
>> >>
>> >> 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. (Success)
>> >> Messages
>> >> * Operating System Service Pack Level Requirement.
>> >>
>> >> * Check Passed
>> >>
>> >>
>> >> - SQL Server Edition Operating System Compatibility (Success)
>> >> Messages
>> >> * SQL Server Edition Operating System Compatibility
>> >>
>> >> * Check Passed
>> >>
>> >>
>> >> - Minimum Hardware Requirement (Success)
>> >> Messages
>> >> * Minimum Hardware Requirement
>> >>
>> >> * Check Passed
>> >>
>> >>
>> >> - IIS Feature Requirement (Success)
>> >> Messages
>> >> * IIS Feature Requirement
>> >>
>> >> * Check Passed
>> >>
>> >>
>> >> - Pending Reboot Requirement (Success)
>> >> Messages
>> >> * Pending Reboot Requirement
>> >>
>> >> * Check Passed
>> >>
>> >>
>> >> - Performance Monitor Counter Requirement (Success)
>> >> Messages
>> >> * Performance Monitor Counter 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 (Warning)
>> >> Messages
>> >> * ASP.Net Version Registration Requirement
>> >>
>> >> * Failed to find the ASP.Net Version Registration with Microsoft
>> >> Internet
>> >> Information Services (IIS).
>> >>
>> >>
>> >> - Minimum MDAC Version Requirement (Success)
>> >> Messages
>> >> * Minimum MDAC Version Requirement
>> >>
>> >> * Check Passed
>> >>
>> >>
>> >> - Edition Change Check (Success)
>> >> Messages
>> >> * Edition Change Check
>> >>
>> >> * Check Passed
>> >>
>> >>
>> >>
>> >> Thanks
>> >>
>>|||I have no clue what do I need to do on my Vista to make RS running, not even
running, at least get installed.
I think it's time for a modern OS to have "Format hard drive" as addition to
Ok, Cancel.
"Aussie Matt" <AussieMatt@.discussions.microsoft.com> wrote in message
news:0EDEC0DE-B6FE-4F75-9C77-1BC63068D9D7@.microsoft.com...
> Mark,
> You will either need to enable ASP on II6 (Disabled by default) or
> register
> it so you can then enable it, to register refer
> http://msdn2.microsoft.com/en-us/library/k6h9cz8h(VS.80).aspx
> to enable,
> Open IIS Manager > Select Web Service Extensions, select the appropiate
> service and "Allow" it..
> Cheers
> Matt
>
>
> "Markgoldin" wrote:
>> I have this report while installing this product.
>> Something about ASP.NET. O yes, it is Vista Business.
>> 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. (Success)
>> Messages
>> * Operating System Service Pack Level Requirement.
>> * Check Passed
>>
>> - SQL Server Edition Operating System Compatibility (Success)
>> Messages
>> * SQL Server Edition Operating System Compatibility
>> * Check Passed
>>
>> - Minimum Hardware Requirement (Success)
>> Messages
>> * Minimum Hardware Requirement
>> * Check Passed
>>
>> - IIS Feature Requirement (Success)
>> Messages
>> * IIS Feature Requirement
>> * Check Passed
>>
>> - Pending Reboot Requirement (Success)
>> Messages
>> * Pending Reboot Requirement
>> * Check Passed
>>
>> - Performance Monitor Counter Requirement (Success)
>> Messages
>> * Performance Monitor Counter 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 (Warning)
>> Messages
>> * ASP.Net Version Registration Requirement
>> * Failed to find the ASP.Net Version Registration with Microsoft
>> Internet
>> Information Services (IIS).
>>
>> - Minimum MDAC Version Requirement (Success)
>> Messages
>> * Minimum MDAC Version Requirement
>> * Check Passed
>>
>> - Edition Change Check (Success)
>> Messages
>> * Edition Change Check
>> * Check Passed
>>
>> Thanks

integrated authentication

Hi,

I am writing project in asp .net with sql server 2005. But I need support him by some applications like deamon in linux systems.(but it will be in windows) So i write it in java. I download jdbc driver and install it. I wrote simple project:

package MainW;

//import javax.mail.*;

//import javax.mail.internet.*;

//import com.sun.mail.smtp.*;

//import javax.swing.*;

//import java.awt.*;

//import java.awt.event.*;

//import java.io.*;

import java.sql.*;

//import java.text.DateFormat;

//import java.text.SimpleDateFormat;

//import java.util.*;

//import java.util.Date;

class Main

{

public static void main(String[] args)

{

String connectionUrl = "jdbc:" + "sqlserver://localhost;databaseName=ASPNETDB.MDF;IntegratedSecurity=True";

Connection con = null;

Statement stmt = null;

ResultSet rs = null;

try

{

Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");

con = DriverManager.getConnection(connectionUrl);

String SQL = "SELECT * FROM aspnet_Users";

stmt = con.createStatement();

rs = stmt.executeQuery(SQL);

// Iterate through the data in the result set and display it.

while (rs.next())

{

System.out.println(rs.getString(4) + " " + rs.getString(6));

}

}

catch (Exception e)

{

e.printStackTrace();

}

finally

{

if (rs != null) try { rs.close(); } catch(Exception e) {}

if (stmt != null) try { stmt.close(); } catch(Exception e) {}

if (con != null) try { con.close(); } catch(Exception e) {}

}

}

}

But i have error:

2007-08-20 15:20:59 com.microsoft.sqlserver.jdbc.AuthenticationJNI SNISecGenClientContext

WARNING: Initialize context failed

2007-08-20 15:20:59 com.microsoft.sqlserver.jdbc.SQLServerConnection SSPIData

WARNING: ConnectionID:1 TransactionID:0x0000000000000000 Authentication failed code-2146893052

com.microsoft.sqlserver.jdbc.SQLServerException: This driver is not configured for integrated authentication.

at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown Source)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.SSPIData(Unknown Source)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(Unknown Source)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(Unknown Source)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.access$000(Unknown Source)

at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(Unknown Source)

at com.microsoft.sqlserver.jdbc.TDSCommand.execute(Unknown Source)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(Unknown Source)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(Unknown Source)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.loginWithoutFailover(Unknown Source)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(Unknown Source)

at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown Source)

at java.sql.DriverManager.getConnection(Unknown Source)

at java.sql.DriverManager.getConnection(Unknown Source)

at MainW.Main.main(Main.java:29)

I am googling about this error second day but i cannot find solve.

Please help.

The failure code -2146893052 is 0x80090304. Some results on the Internet mentions firewall blocking the SQL Server TCP port, but since you are connecting to the local machine it should not be a problem. I also heard of out of memory scenarios causing this error to be raised.

I think it would be helpful if you can mention the environment setup you are running the app under. Also, which SQL Server 2005 edition on you using?

Some things you may consider trying:

On the same machine, try running the "sqlcmd" tool that comes with SQL Server 2005 to see if you get the same error

sqlcmd -Slocalhost -E

Integrated Auth and SQL servers

I'm building a reporting server that will grab data off of a an old HP3000, all of that is being done in a background task (non asp.net) and uploaded to an sql server.

I'm using a web interface to allow people within the company to view the data. This will be in a single domain, behind a firewall, and will not be accessable from outside of the company.

In IIS, I have anonymous login unchecked and only Integrated Windows Auth checked. The pertinate parts of my web.config look like this:

<authenticationmode="Windows"/>

<identityimpersonate="true"/>

<authorization>

<allowusers="*"/>

<denyusers="?"/>

</authorization>

My connection string looks like this:

publicstaticstring SqlServerConnect = "Integrated Security=SSPI;Initial Catalog=[name of database];Data Source=[sqlserver IP]";

The website (for now) is on my local development computer. When I run the program everything works fine, when I attempt to view the web page on another computer, I get the following error

Server Error in '/reports' Application.

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

I'm at a loss as to how to fix this. I dont really want each user to have to enter any log in information, frankly, the permissions dont even matter in this case. My main problem is with the sql connection and trying to get adequate permissions to run queries.

Any help would be apprieciated

<deny users="?" /> denyANONYMOUS user. Ifthe permissions dont even matter and you dont really want each user to have to enter any log in information, then you can remove this <deny users="?" /> in web.config <authorization> section.

|||

Xiaohong wrote:

<deny users="?" /> denyANONYMOUS user. Ifthe permissions dont even matter and you dont really want each user to have to enter any log in information, then you can remove this <deny users="?" /> in web.config <authorization> section.

This all gets back to the security problem with the sql connection. It generates error messages when it gets to the sqlCommand.Fill(dataset) part. If I dont do some kind of authentication, the sqlconnect returns an error message. I just need enough permissions to connect to the sql server

Integrate Reports in ASP.Net Web Form

Hi,
I have my reports at http:\\localhost\ReportServer and need to use them in
ASP.NET Web Form.I have a few questions reg. this
--> I want to generate a PDF when a button labeled "Generate Report" is
clicked"
(1) I tried this using the below code:
Dim myResponse As Byte()
Dim url As String = http://localhost/reportserver?/Reports/Sales
Invoice&ORDER_ID=1879&rs:Format=PDF
Dim myWebClient As New WebClient
myWebClient.Credentials = CredentialCache.DefaultCredentials
myResponse = myWebClient.DownloadData(url)
Response.ContentType = "application/pdf"
Response.AddHeader("content-disposition", "attachment; filename=Sales
Invoice.PDF")
Response.BinaryWrite(myResponse)
But got the error "The remote server returned an error: (403) Forbidden"
I have included "<identity impersonate="true"/>" in Web.Config File.
This Error is because the Credentials is null. I don't know why the
credentials are null even after I use myWebClient.Credentials = CredentialCache.DefaultCredentials
The same code works if I Create new Credentials specifying UserName and
Password. But I am cannot specify Username and password. The Application has
take the credentials from the server.
(2) Why can't I use the following one line of code(This works, I want to
know are there any kind issues with
this)Response.Redirect(http://localhost/reportserver?/Reports/Sales
Invoice&ORDER_ID=1879&rs:Format=PDF)
(3) What are other ways to integrate reports with ASP.NET Web Form.
(4)I need to deploy the Reports that I created in my machine to the server
I tried to deploy setting TargetServerURL=http://servername/ReportServer in
Project Properties, but got the error
"The permissions granted to user are insufficient for performing this
operation". What kind of permissions are required.
(5)What are different ways to deploy Reports on a Server.It sounds like you are running into the double hop issue. You can not make
an impersonated call to another machine if you are currently impersonated,
unless the machines trust one another. You would need to set up Kerberos to
get the machines to trust each other.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Kiran" <Kiran@.nospam.net> wrote in message
news:O7VH3Z35EHA.1564@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I have my reports at http:\\localhost\ReportServer and need to use them in
> ASP.NET Web Form.I have a few questions reg. this
> --> I want to generate a PDF when a button labeled "Generate Report"
> is clicked"
> (1) I tried this using the below code:
> Dim myResponse As Byte()
> Dim url As String = http://localhost/reportserver?/Reports/Sales
> Invoice&ORDER_ID=1879&rs:Format=PDF
> Dim myWebClient As New WebClient
> myWebClient.Credentials = CredentialCache.DefaultCredentials
> myResponse = myWebClient.DownloadData(url)
> Response.ContentType = "application/pdf"
> Response.AddHeader("content-disposition", "attachment; filename=Sales
> Invoice.PDF")
> Response.BinaryWrite(myResponse)
> But got the error "The remote server returned an error: (403) Forbidden"
> I have included "<identity impersonate="true"/>" in Web.Config File.
> This Error is because the Credentials is null. I don't know why the
> credentials are null even after I use myWebClient.Credentials => CredentialCache.DefaultCredentials
> The same code works if I Create new Credentials specifying UserName and
> Password. But I am cannot specify Username and password. The Application
> has take the credentials from the server.
> (2) Why can't I use the following one line of code(This works, I want to
> know are there any kind issues with
> this)Response.Redirect(http://localhost/reportserver?/Reports/Sales
> Invoice&ORDER_ID=1879&rs:Format=PDF)
> (3) What are other ways to integrate reports with ASP.NET Web Form.
> (4)I need to deploy the Reports that I created in my machine to the server
> I tried to deploy setting TargetServerURL=http://servername/ReportServer
> in Project Properties, but got the error
> "The permissions granted to user are insufficient for performing this
> operation". What kind of permissions are required.
> (5)What are different ways to deploy Reports on a Server.
>|||For deploying you should have rights in the report server to deploy report.
Log on to the machine to which you are tryiong to deploy , open the report
manager and under security add yourself as a user with deployment rights.
Reponse.Redirect works fine for me. also have you tried using report viewer
HTH
"Kiran" <Kiran@.nospam.net> wrote in message
news:O7VH3Z35EHA.1564@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I have my reports at http:\\localhost\ReportServer and need to use them in
> ASP.NET Web Form.I have a few questions reg. this
> --> I want to generate a PDF when a button labeled "Generate Report"
> is clicked"
> (1) I tried this using the below code:
> Dim myResponse As Byte()
> Dim url As String = http://localhost/reportserver?/Reports/Sales
> Invoice&ORDER_ID=1879&rs:Format=PDF
> Dim myWebClient As New WebClient
> myWebClient.Credentials = CredentialCache.DefaultCredentials
> myResponse = myWebClient.DownloadData(url)
> Response.ContentType = "application/pdf"
> Response.AddHeader("content-disposition", "attachment; filename=Sales
> Invoice.PDF")
> Response.BinaryWrite(myResponse)
> But got the error "The remote server returned an error: (403) Forbidden"
> I have included "<identity impersonate="true"/>" in Web.Config File.
> This Error is because the Credentials is null. I don't know why the
> credentials are null even after I use myWebClient.Credentials => CredentialCache.DefaultCredentials
> The same code works if I Create new Credentials specifying UserName and
> Password. But I am cannot specify Username and password. The Application
> has take the credentials from the server.
> (2) Why can't I use the following one line of code(This works, I want to
> know are there any kind issues with
> this)Response.Redirect(http://localhost/reportserver?/Reports/Sales
> Invoice&ORDER_ID=1879&rs:Format=PDF)
> (3) What are other ways to integrate reports with ASP.NET Web Form.
> (4)I need to deploy the Reports that I created in my machine to the server
> I tried to deploy setting TargetServerURL=http://servername/ReportServer
> in Project Properties, but got the error
> "The permissions granted to user are insufficient for performing this
> operation". What kind of permissions are required.
> (5)What are different ways to deploy Reports on a Server.
>

Installing SQL SERVER 2000 on XP

Hi.. ASP

I want to install SQL SERVER 2000 on XP..But is it only support for client version.

Is there any Service Pack for XP about SQL SERVER 2000 for server version. I have already install XpServicePack2 but problem is still remain.

Thanks & Regards

Ravinder Sharma

No you can install the developer edition, personal and any eval edition. Hope this helps.

Installing SQL 2005 Express w/ Advance feature

I am trying to install SQL 2005 Express w/ Advance feature. I
installed IIS with ASP.NET but the installation still complain I don't
have IIS installed or enabled. Do I miss anything else?
Your installation sequence should be as follows:
1) IIS
2) .NET Framework 2.0
3) SQL Server 2005 Express
If you were not able to do this in sequence, I would recommend running
aspnet_regiis.exe -i to install ASP.NET 2.0 in IIS. Make sure you are
running the correct version which is v2.0
"melon" <elty123@.gmail.com> wrote in message
news:1184014812.202660.102940@.57g2000hsv.googlegro ups.com...
>I am trying to install SQL 2005 Express w/ Advance feature. I
> installed IIS with ASP.NET but the installation still complain I don't
> have IIS installed or enabled. Do I miss anything else?
>
|||I am using Vistaand using .NET framework 3.0. Does it matter?
I also verfied that my IIS is running with ASP.NET enabled.
On Jul 10, 1:10 am, "bass_player [SBS-MVP]" <bass_pla...@.mvps.org>
wrote:
> Your installation sequence should be as follows:
> 1) IIS
> 2) .NET Framework 2.0
> 3) SQL Server 2005 Express
> If you were not able to do this in sequence, I would recommend running
> aspnet_regiis.exe -i to install ASP.NET 2.0 in IIS. Make sure you are
> running the correct version which is v2.0
> "melon" <elty...@.gmail.com> wrote in message
> news:1184014812.202660.102940@.57g2000hsv.googlegro ups.com...
>
>
> - Show quoted text -

Installing SQL 2005 Express w/ Advance feature

I am trying to install SQL 2005 Express w/ Advance feature. I
installed IIS with ASP.NET but the installation still complain I don't
have IIS installed or enabled. Do I miss anything else?Your installation sequence should be as follows:
1) IIS
2) .NET Framework 2.0
3) SQL Server 2005 Express
If you were not able to do this in sequence, I would recommend running
aspnet_regiis.exe -i to install ASP.NET 2.0 in IIS. Make sure you are
running the correct version which is v2.0
"melon" <elty123@.gmail.com> wrote in message
news:1184014812.202660.102940@.57g2000hsv.googlegroups.com...
>I am trying to install SQL 2005 Express w/ Advance feature. I
> installed IIS with ASP.NET but the installation still complain I don't
> have IIS installed or enabled. Do I miss anything else?
>|||I am using Vistaand using .NET framework 3.0. Does it matter?
I also verfied that my IIS is running with ASP.NET enabled.
On Jul 10, 1:10 am, "bass_player [SBS-MVP]" <bass_pla...@.mvps.org>
wrote:
> Your installation sequence should be as follows:
> 1) IIS
> 2) .NET Framework 2.0
> 3) SQL Server 2005 Express
> If you were not able to do this in sequence, I would recommend running
> aspnet_regiis.exe -i to install ASP.NET 2.0 in IIS. Make sure you are
> running the correct version which is v2.0
> "melon" <elty...@.gmail.com> wrote in message
> news:1184014812.202660.102940@.57g2000hsv.googlegroups.com...
>
> >I am trying to install SQL 2005 Express w/ Advance feature. I
> > installed IIS with ASP.NET but the installation still complain I don't
> > have IIS installed or enabled. Do I miss anything else... Hide quoted text -
> - Show quoted text -

Installing SQL 2005 Express w/ Advance feature

I am trying to install SQL 2005 Express w/ Advance feature. I
installed IIS with ASP.NET but the installation still complain I don't
have IIS installed or enabled. Do I miss anything else?Your installation sequence should be as follows:
1) IIS
2) .NET Framework 2.0
3) SQL Server 2005 Express
If you were not able to do this in sequence, I would recommend running
aspnet_regiis.exe -i to install ASP.NET 2.0 in IIS. Make sure you are
running the correct version which is v2.0
"melon" <elty123@.gmail.com> wrote in message
news:1184014812.202660.102940@.57g2000hsv.googlegroups.com...
>I am trying to install SQL 2005 Express w/ Advance feature. I
> installed IIS with ASP.NET but the installation still complain I don't
> have IIS installed or enabled. Do I miss anything else?
>|||I am using Vistaand using .NET framework 3.0. Does it matter?
I also verfied that my IIS is running with ASP.NET enabled.
On Jul 10, 1:10 am, "bass_player [SBS-MVP]" <bass_pla...@.mvps.org>
wrote:
> Your installation sequence should be as follows:
> 1) IIS
> 2) .NET Framework 2.0
> 3) SQL Server 2005 Express
> If you were not able to do this in sequence, I would recommend running
> aspnet_regiis.exe -i to install ASP.NET 2.0 in IIS. Make sure you are
> running the correct version which is v2.0
> "melon" <elty...@.gmail.com> wrote in message
> news:1184014812.202660.102940@.57g2000hsv.googlegroups.com...
>
>
> - Show quoted text -

Installing SQL

I am learning ASP.NET from teach yourself ASP.NET in 24 hours. When i try to connect to the SQL Server i get an error "SQL Server does not exist or access denied".

SQL appears to exist, and to be running. I am trying to connect through Localhost.

Where should i be looking if access is being denied by a firewall and how should i disable it

Connection to local SQL always uses Shared Memory Network Library by default, which should not be blocked. Please post your error message and connection string.

|||

Hi Lori-Jay

The message is:

Unable to connect to database server.

SQL does not exist or access denied.

ConnectionOpen(Connect())

|||Hi, did you forget to post your connection string?|||

Hi,

Where do i find the connection string? I am simply using the example in the book which gives me some buttons and text boxes to fill in.

These are

SQL Server authentication button on

User name which I completed as instructed as SA

And the password which I used to install MSDE

And then I hit "Create a new database"

I then got the error above.

Where would I find the connection string?

|||

So you're using MSDE, thus leads us closer to the answer. Are you using ASP.NET 2.0? Sorry I'm not familiar with the example you mentioned, so if possible please give a link that I can follow to try the sample. Is it something like this?

http://download.microsoft.com/download/C/3/8/C3888A3E-52F8-4FE9-8E41-89150AB0302F/CreateDB.zip.exe

If yes, please open to sample solution with VS2005 and right click the form where you create the database (Form1.vb in this sample) in Solution Explorer, choose View Code. You should see some code like this:

Public Class Form1

' Initialize constants for connecting to the database
' and displaying a connection error to the user.
Protected Const SqlConnectionString As String = _
"Server=(local);" & _
"DataBase=;" & _
"Integrated Security=SSPI"

Protected Const ConnectionErrorMessage As String = _
"To run this sample, you must have SQL " & _
"installed. For " & _
"instructions on installing SQL, view the documentation file."

Protected didPreviouslyConnect As Boolean = False
Protected didCreateTable As Boolean = False
Protected connectionString As String = SqlConnectionString

.....

And explorer the 'Create database section you'll find this line which gets connectionString:

Dim connection As New SqlConnection(connectionString)

As we can see the default connection is made to local default SQL instance. So what you need to do is customizing the const that host connection string to point to your MSDE server name. For example:

"Server=myServer\myMSDESvr;" & _
"DataBase=;" & _
"Integrated Security=SSPI"