Is the workgroup edition suitable for a web application?

Hi,
well, the title says it all already. Are there any technical
limitations that could prevent using the WG edition with asp.net?
Oh, and are there licensing limitations (is it even allowed to run the
WG edition in a web server environment) ?Hi,
Here, you can find info about SQL Server 2005 Workgroup Edition:
http://www.microsoft.com/sql/editions/workgroup/default.mspx
Here, you can find info about SQL Server 2005 Edition comparison:
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
Ekrem Önsoy
<PSiegmann@.mail.nu> wrote in message
news:1188925296.970273.139890@.50g2000hsm.googlegroups.com...
> Hi,
> well, the title says it all already. Are there any technical
> limitations that could prevent using the WG edition with asp.net?
> Oh, and are there licensing limitations (is it even allowed to run the
> WG edition in a web server environment) ?
>

Is the Certificate based authentication the only way ?

1.On an virtual server two virtual machines of Windows 2003+sql server 2005 developer edition named VM1 and VM2

2.The VMs are not on a domain.

3.endpoint uses windows authentication

I get the following error

Msg 1418, Level 16, State 1, Line 1
The server network address "TCP://x.x.x.x:5022" can not be reached or does not exist. Check the network address name and that the ports for the local and remote endpoints are operational.

and the log file contains the following

07/26/2007 19:21:22,Logon,Unknown,Database Mirroring login attempt failed with error: 'Connection handshake failed. An OS call failed: (8009030e) 0x8009030e(No credentials are available in the security package). State 65.'. [CLIENT: x.x.x.x]
07/26/2007 19:21:19,Logon,Unknown,Database Mirroring login attempt failed with error: 'Connection handshake failed. An OS call failed: (8009030e) 0x8009030e(No credentials are available in the security package). State 65.'. [CLIENT: x.x.x.x]
07/26/2007 19:21:17,Logon,Unknown,Database Mirroring login attempt failed with error: 'Connection handshake failed. An OS call failed: (8009030e) 0x8009030e(No credentials are available in the security package). State 65.'. [CLIENT: x.x.x.x]
07/26/2007 19:21:14,Logon,Unknown,Database Mirroring login attempt failed with error: 'Connection handshake failed. An OS call failed: (8009030e) 0x8009030e(No credentials are available in the security package). State 65.'. [CLIENT: x.x.x.x]
07/26/2007 19:21:12,Logon,Unknown,Database Mirroring login attempt failed with error: 'Connection handshake failed. An OS call failed: (8009030e) 0x8009030e(No credentials are available in the security package). State 65.'. [CLIENT: x.x.x.x]
07/26/2007 19:21:10,Logon,Unknown,Database Mirroring login attempt failed with error: 'Connection handshake failed. An OS call failed: (8009030e) 0x8009030e(No credentials are available in the security package). State 65.'. [CLIENT: x.x.x.x]
07/26/2007 19:21:09,Logon,Unknown,Database Mirroring login attempt failed with error: 'Connection handshake failed. An OS call failed: (8009030e) 0x8009030e(No credentials are available in the security package). State 65.'. [CLIENT: x.x.x.x]
07/26/2007 19:21:08,Logon,Unknown,Database Mirroring login attempt failed with error: 'Connection handshake failed. An OS call failed: (8009030e) 0x8009030e(No credentials are available in the security package). State 65.'. [CLIENT: x.x.x.x]
07/26/2007 19:21:06,spid25s,Unknown,Database mirroring connection error 5 'Connection handshake failed. An OS call failed: (8009030e) 0x8009030e(No credentials are available in the security package). State 65.' for 'TCP://x.x.x.x:5022'.
07/26/2007 19:21:06,spid25s,Unknown,Error: 1474<c/> Severity: 16<c/> State: 1.
07/26/2007 19:21:06,Logon,Unknown,Database Mirroring login attempt failed with error: 'Connection handshake failed. An OS call failed: (8009030e) 0x8009030e(No credentials are available in the security package). State 65.'. [CLIENT: x.x.x.x]

Is there anyway i can do mirroring without certificates,

guys any pointers?

i think the partners namely principal and mirror server shud have either standard or enterprise edition to configure mirroring..........but the error seems to be different........just check the ports using the command netstat -ano whether the port you specify is used somewhere........also try to give the fully qualified server name.........

|||

1. Developer edition supports

2.The specified port is not being used

3.Since the macine is not on a domain i cannot give the fully qualified path alternatively i have used ip.

|||

I don't know if this will make you feel better or not but let me tell you that I as well was looking into setting up mirroring with all sorts of tricks not to use certificate authentication.

But trust me, for 2 computers not in the same domain this is the best way. It saves you a lot of trouble with permissions and all sorts of *** errors.

Do it using transact sql commands following microsoft example and it will work! I got mine up and running ever since.

|||

I had the same error even after bringing the servers under a single domain.

The following is the change I made

Changed the Authentication type from Kerbrose to NTLM.

It all works fine when servers are under same domain.

Need to check when the servers are not under a Domain.

|||partners need to be either std or enterprise edition...refer,
http://msdn2.microsoft.com/en-us/library/ms366349.aspx

Is SQL Server Service Manager still existing on SQL Express Edition?

Hi there. I am new to the SQL Express. I just finished installing the SQL Express 2005 with Advanced Services on a Windows XP SP2 computer. The first thing I noticed was the service manager (used to be on the taskbar) was being removed on the Express Edition. How do I get this feature back if it's even possible? I know you can find out the server status from the Configuration Manager but it's handy if the status is showned on the taskbar after logging in.

Any help will be greatly appreciated. Thank you.

KC

There is no Service Manager in any SKU of SQL Server 2005. There are some folks out there that have written their own however.

Is SQL Server 2005 Express Edition with Advanced Services FREE ?

I can't find any information on this. Thanks.

Yep, it's free.

Regards,

Mike Wachal
SQL Express team

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

is sql server 2005 a standalone install? Or do you have to install windows server

I have never installed sql server before and I didnt know if I just take the sql server 2005 standard edition media and boot off it and do a fresh install that way or do I have to install Windows server

SQL Server is "just" a database*. You need an underlying operating system in place before you attempt to install it. For SQL Server 2005, supported operating systems are Windows 2000, Windows XP, and Windows Server 2003. Not all versions of SQL Server 2005 are supported on all these operating systems, but I believe the standard edition of SQL is.

Paul

*Well, a database and tools and report server and... But it's not an operating system.

|||thanks, that exacty what i needed to hear.

Is SERVER OS Software needed with SQL Server?

I am learning VB.Net and ADO.Net database programming, so
I bought MS SQL Server 2000 Developer Edition. I need
some guidance on how to set it up over my LAN.
I installed SQL Server 2000 on a Win 2k Pro machine. I
would like to serve from here, then use a Win XP machine
for client apps for testing. When installing SQL Server, I
gave it a new domain name when asked. But i can't get the
client machine to find the domain. Is a DNS issue? Does
the SQL Server machine have to run Win 2k SERVER to get it
to be a DSN server? I hope not, can't afford Win Server OS
at this time. Thanks in advance."Larry" <anonymous@.discussions.microsoft.com> wrote in message
news:009001c3d3a3$f5179800$a101280a@.phx.gbl...
> I am learning VB.Net and ADO.Net database programming, so
> I bought MS SQL Server 2000 Developer Edition. I need
> some guidance on how to set it up over my LAN.
> I installed SQL Server 2000 on a Win 2k Pro machine. I
> would like to serve from here, then use a Win XP machine
> for client apps for testing. When installing SQL Server, I
> gave it a new domain name when asked. But i can't get the
> client machine to find the domain. Is a DNS issue? Does
> the SQL Server machine have to run Win 2k SERVER to get it
> to be a DSN server? I hope not, can't afford Win Server OS
> at this time. Thanks in advance.
You don't need a server to perform you testing... I'm not sure I understand
what you mean by "domain" name. Are your computers part of a workgroup?
Assuming that SQL Server is installed correctly and running, have you
enabled the File and Printer sharing from your W2K client? To rule out DNS
issues, from your XP client try connecting to your SQL Server by using the
IP address of that W2K machine.
Steve

Is MSDE supported by Microsoft SQL Server 2000 driver for JDBC?

I have J2EE web application, that uses Datasources, which works fine with SQL
Server 2000 Developer Edition running on Windows 2000 Server but I am having
issues with running the same code against MSDE version of SQL Server 2000
running locally on Windows XP Professional.
Is MSDE version of SQL server supported by Microsoft SQL Server 2000 driver
forJDBC?
The release notes says:
The following versions of SQL Server will be supported for use with the SQL
Server 2000 Driver for JDBC SP2:
? SQL Server 2000 Standard and Enterprise Editions*
? SQL Server 2000 Standard and Enterprise Editions with Service Pack 1 or
higher*
? SQL Server 2000 Enterprise Edition (64-bit)*
MSDE should act the same as any other flavor of SQL 2000 with the exception
of a few well documented limitations. Likely, you have not enabled Network
protocals?
Also, the docs you reference below sound very old. SQL needs to be at SP3 or
3A. Any current download of MSDE will be at the 3A SP level.
-Andrew
"Kris" <Kris@.discussions.microsoft.com> wrote in message
news:AC61CEC6-2D96-418E-810B-E59F8B87356B@.microsoft.com...
> I have J2EE web application, that uses Datasources, which works fine with
SQL
> Server 2000 Developer Edition running on Windows 2000 Server but I am
having
> issues with running the same code against MSDE version of SQL Server 2000
> running locally on Windows XP Professional.
> Is MSDE version of SQL server supported by Microsoft SQL Server 2000
driver
> forJDBC?
> The release notes says:
> The following versions of SQL Server will be supported for use with the
SQL
> Server 2000 Driver for JDBC SP2:
> . SQL Server 2000 Standard and Enterprise Editions*
> . SQL Server 2000 Standard and Enterprise Editions with Service Pack 1 or
> higher*
> . SQL Server 2000 Enterprise Edition (64-bit)*

Is MSDE supported by Microsoft SQL Server 2000 driver for JDBC

I have J2EE web application, that uses Datasources, which works fine with SQL
Server 2000 Developer Edition running on Windows 2000 Server but I am having
issues with the same code running locally on Windows XP Professional against
MSDE version of SQL Server 2000.
Is MSDE version of SQL server supported by Microsoft SQL Server 2000 driver
forJDBC?
The release notes says:
The following versions of SQL Server will be supported for use with the SQL
Server 2000 Driver for JDBC SP2:
? SQL Server 2000 Standard and Enterprise Editions*
? SQL Server 2000 Standard and Enterprise Editions with Service Pack 1 or
higher*
? SQL Server 2000 Enterprise Edition (64-bit)*
Do you have specifics on the issues? For instance, could it be your Windows
Firewall? If it is on, it must be configured to allow traffic (locally) on
ports 1433 (TCP) and 1434 (UDP). I don't know any specifics about the JDBC
drivers, other than make sure that you have the same SQL Server SP
(preferably SP3/SP3a) and check your MDAC version against the other
machine's.
"Kris" <Kris@.discussions.microsoft.com> wrote in message
news:A3942A4E-398A-48FA-B363-A4D392E2ECBB@.microsoft.com...
>I have J2EE web application, that uses Datasources, which works fine with
>SQL
> Server 2000 Developer Edition running on Windows 2000 Server but I am
> having
> issues with the same code running locally on Windows XP Professional
> against
> MSDE version of SQL Server 2000.
> Is MSDE version of SQL server supported by Microsoft SQL Server 2000
> driver
> forJDBC?
> The release notes says:
> The following versions of SQL Server will be supported for use with the
> SQL
> Server 2000 Driver for JDBC SP2:
> . SQL Server 2000 Standard and Enterprise Editions*
> . SQL Server 2000 Standard and Enterprise Editions with Service Pack 1 or
> higher*
> . SQL Server 2000 Enterprise Edition (64-bit)*

Is MSDE supported by Microsoft SQL Server 2000 driver for JDBC

I have J2EE web application, that uses Datasources, which works fine with SQ
L
Server 2000 Developer Edition running on Windows 2000 Server but I am having
issues with the same code running locally on Windows XP Professional against
MSDE version of SQL Server 2000.
Is MSDE version of SQL server supported by Microsoft SQL Server 2000 driver
forJDBC?
The release notes says:
The following versions of SQL Server will be supported for use with the SQL
Server 2000 Driver for JDBC SP2:
? SQL Server 2000 Standard and Enterprise Editions*
? SQL Server 2000 Standard and Enterprise Editions with Service Pack 1 or
higher*
? SQL Server 2000 Enterprise Edition (64-bit)*Do you have specifics on the issues? For instance, could it be your Windows
Firewall? If it is on, it must be configured to allow traffic (locally) on
ports 1433 (TCP) and 1434 (UDP). I don't know any specifics about the JDBC
drivers, other than make sure that you have the same SQL Server SP
(preferably SP3/SP3a) and check your MDAC version against the other
machine's.
"Kris" <Kris@.discussions.microsoft.com> wrote in message
news:A3942A4E-398A-48FA-B363-A4D392E2ECBB@.microsoft.com...
>I have J2EE web application, that uses Datasources, which works fine with
>SQL
> Server 2000 Developer Edition running on Windows 2000 Server but I am
> having
> issues with the same code running locally on Windows XP Professional
> against
> MSDE version of SQL Server 2000.
> Is MSDE version of SQL server supported by Microsoft SQL Server 2000
> driver
> forJDBC?
> The release notes says:
> The following versions of SQL Server will be supported for use with the
> SQL
> Server 2000 Driver for JDBC SP2:
> . SQL Server 2000 Standard and Enterprise Editions*
> . SQL Server 2000 Standard and Enterprise Editions with Service Pack 1 or
> higher*
> . SQL Server 2000 Enterprise Edition (64-bit)*