Netware, MS SQL Server , Logins

Posted in Sql Server Setup Newsgroup as well.
I have a MS Sql Server 2000 application. The LAN environment is Novell Netw
are 5.x. with NO Windows domain. The network layer is TCP/IP and IPX/SPX. L
arge network with many users (500+), thus slow to change.
The client workstation OS that is going to attach to the Sql Server app are
Windows NT 4.0. The workstations load the Novell Netware client as the prim
ary client and authenicate there. The Novell Netware client is "checked" t
o logon to Windows Workstat
ion locally.
Here is the delimma. No Windows domain seems to rule out NT Authenicated se
curity on Sql Server. Sql Server authenication will be tough to maintain du
e to number of users.
1. Can the Novell login name/ psw be used in any way?
2. Can the Sql Server and the Novell LAN be intergrated in a way that would
help in this situation?
3. What would you do?
Thanks,
BrianPrevious Post:
Here is the delimma. No Windows domain seems to rule out NT Authenicated
security on Sql Server. Sql Server authenication will be tough to maintain
due to number of users.
1. Can the Novell login name/ psw be used in any way?
2. Can the Sql Server and the Novell LAN be intergrated in a way that would
help in this situation?
3. What would you do?
Reply:
1. No. You'd have to login to both Novell and a Windows DC.
2. Without a domain. You can only use SQL Standard Security with TCP or
IPX/SPX.
3. Use TCP/IP. Enable Protocol Encryption to encrypt the traffic and the
logins. Just putting a server certificate on the SQL machine will encrypt
the logins. Enabling protocol encryption will encrypt all the traffic as
well.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

netstat doesnt show me 1433 port LISTENING

Sometimes when I setup ms SQL Server 2000 in a machine and i run
"netstat -na" doesnt show me 1433 port listening, and sometimes it
does. why is that?
thanke
Hi
Check in the server network utility that you are actually using this port,
if you are using a named instance the default is to allocate the port
dynamically.
John
"ing.edmundo" wrote:

> Sometimes when I setup ms SQL Server 2000 in a machine and i run
> "netstat -na" doesnt show me 1433 port listening, and sometimes it
> does. why is that?
> thanke
>

netstat doesnt show me 1433 port LISTENING

Sometimes when I setup ms SQL Server 2000 in a machine and i run
"netstat -na" doesnt show me 1433 port listening, and sometimes it
does. why is that?
thankeHi
Check in the server network utility that you are actually using this port,
if you are using a named instance the default is to allocate the port
dynamically.
John
"ing.edmundo" wrote:

> Sometimes when I setup ms SQL Server 2000 in a machine and i run
> "netstat -na" doesnt show me 1433 port listening, and sometimes it
> does. why is that?
> thanke
>

netstat doesnt show me 1433 port LISTENING

Sometimes when I setup ms SQL Server 2000 in a machine and i run
"netstat -na" doesnt show me 1433 port listening, and sometimes it
does. why is that?
thankeHi
Check in the server network utility that you are actually using this port,
if you are using a named instance the default is to allocate the port
dynamically.
John
"ing.edmundo" wrote:
> Sometimes when I setup ms SQL Server 2000 in a machine and i run
> "netstat -na" doesnt show me 1433 port listening, and sometimes it
> does. why is that?
> thanke
>

Neither the partner nor the witness server instance for data...

I am getting this error while trying to setup mirroring.
"Neither the partner nor the witness server instance for database "shop" is available. Reissue the command when at least one of the instances becomes available. (Microsoft SQL Server, Error: 1431)"

I am just using principal and mirror server, there is no witness server. I have tried fully qualified name and ip for the servers also. I can connect from the principal server to the mirror server using the management studio and it also creates endpoints on prinicipal and witness. But then gives me an error that it cannot find the instance of the mirror server and if I try again it gives the error above. I can also telnet to port 5022.

I have used -T1400 as the startup parameter.

I did the backup and recovery based on this link http://msdn2.microsoft.com/en-us/library/ms189053.aspx and the mirror server is in recovery mode now.

Can you list the steps you followed when setting up mirroring?

Thanks,

Matt

|||

This error message indicates that the partner thinks that its database should be the principal database, but cannot open the database up because the server needs quorum.

Quorum is required to serve the database if the safety is set to FULL and the witness server has been set. This prevents "split brain". Right now the server doesn't know if the partner and witness have gone ahead and failed over the database to serve it, and so this server leaves its database offline.

If you are getting the "cannot find that server or the instance isn't started" error, then there is a troubleshooting guide in BOL. Most likely it is a security problem.

Thanks,

Mark

|||Hi,

Thanks for the reply. I don't think I need quorum because I am not

using a witness server. The first error message I get after I click on

start mirroring on the wizard is this

"The server network address "TCP://NDIVERSBK:5022" can not be reached

or does not exist. Check the network address name and reissue the

command. (Microsoft SQL Server, Error: 1418)"

I can configure security without any problem and it creates the end

points on both the servers also but I get an error when I click on

start mirroring.

When I click OK and clcik on start mirroing again I get this error message "Neither

the partner nor the witness server instance for database "shop" is

available. Reissue the command when at least one of the instances

becomes available. (Microsoft SQL Server, Error: 1431)".

Both servers are using the same service account and have the same sa

and administrator passwords. They are on the same network and workgroup

but not on a a domain.

The steps I took to setup mirroring was:

1. Setup the SQL service to run on windows account with administrator

permissions and had the same account password on both the servers.

2. Added -T1400 as starup parameter on both servers and restarted them.

3. Backed up the database on the principal server and restored the it on the mirror server using no recovery mode.

4. Backed up a transaction log on primary server and restored it again on mirror in no-recovery mode.

5. Started mirroing wizard using on prinicipal server and cliked the configure secuirty button.

6. Selected only principal and mirror server and no witness server.

7. Set the principal and mirror server instance using the

same endpoint name and listener port and select encrypt data.

8. Left the service accounts principal and mirror blank

9. It created the end points on both servers and we checked

to make sure they are there.

10 Clicked on start mirroring and that’s when we got the

error that it cannot find mirror server first time.

When we clicked OK and clicked on start mirroring again we

got the second error and always shows up and is mentioned above.
We also tried using the sql queries and got the same

error.|||

Excellent repro steps!

OK, 1418 was one of the most mentioned errors that database mirroring had, and so I went and created a specific Books OnLine topic for it. If you search for "troubleshooting database mirroring" in BOL, then you should find the section.

If you have configured SQL to use the SA accounts (like you state you do), then my next guess is that the port is blocked by a firewall. Basically, the first error message (1418)means the principal cannot access the mirror. Then you connect to the mirror, but since it has never talked with the principal, the mirror does not know what state the session is in, and so it returns the 1431 error.

To verify that the endpoint is accessable, open up a command windows and type "telnet NDIVERSBK 5022". If the endpoint is working properly, then the screen should clear, and you should be able to make 16 keystrokes before the connection is terminated. If you can't do that, the port is probably blocked. If you can do that, we'll start looking in the errorlog files.

Thanks,

Mark

|||There is no firewall between the servers and I tried opening up a command windows and type "telnet NDIVERSBK 5022". The screen cleared, and I was able to make 16 keystrokes before the connection got terminated.

Thanks for your help.

|||

OK, the endpoints are waiting for connections...

Hmmmm...

If the endpoints are configured properly, and you can telnet into the endpoint from each server to the other server, then my guess is that the problem is security.

Could you send me the errorlogs from both servers that have the errors recorded in log?

Normally the errorlogs are in "Program Files\Microsoft SQL Server\MSSQL.n\MSSQL\LOG\ERRORLOG" by default.

mwistrom@.microsoft.com

Thanks,

Mark

|||I have emailed the log file to the email address you provided. Thanks.|||Can this be a problem for mirroring:

The database owner is sa and I am logging in as sa in Management

Studio. But when I click on Database diagrams I get the following error

"Database diagram support objects cannot be installed because this

database does not have a valid owner. To continue, first use the Files

page of the Database Properties dialog box or the ALTER AUTHORIZATION

statement to set the database owner to a valid login, then add the

database diagram support objects."|||

I also already tried FQDN using this line

Alter database db set partner = 'NDIVERSBK.dds.com:5022' and this also does

not work and I still get the same error.

When I try to telnet to NDIVERSBK.dds.com at port 5022 the blank black

screen stay only for a second and then goes without any keystrokes.

|||

Don't forget that the syntax is 'tcp://ndiversbk.dds.com:5022'

If the telnet kicks you out after 1 second, then there is a problem with security and the endpoint. It should let you type 16 keystrokes and then kick you out.

Did you specify the 1400 trace flag?

|||

Just try

drop endpoint [mirroring]

in both server and restart the process

[];s

Marcelo Glauco

Neither the partner nor the witness server instance for data...

I am getting this error while trying to setup mirroring.
"Neither the partner nor the witness server instance for database "shop" is available. Reissue the command when at least one of the instances becomes available. (Microsoft SQL Server, Error: 1431)"

I am just using principal and mirror server, there is no witness server. I have tried fully qualified name and ip for the servers also. I can connect from the principal server to the mirror server using the management studio and it also creates endpoints on prinicipal and witness. But then gives me an error that it cannot find the instance of the mirror server and if I try again it gives the error above. I can also telnet to port 5022.

I have used -T1400 as the startup parameter.

I did the backup and recovery based on this link http://msdn2.microsoft.com/en-us/library/ms189053.aspx and the mirror server is in recovery mode now.

Can you list the steps you followed when setting up mirroring?

Thanks,

Matt

|||

This error message indicates that the partner thinks that its database should be the principal database, but cannot open the database up because the server needs quorum.

Quorum is required to serve the database if the safety is set to FULL and the witness server has been set. This prevents "split brain". Right now the server doesn't know if the partner and witness have gone ahead and failed over the database to serve it, and so this server leaves its database offline.

If you are getting the "cannot find that server or the instance isn't started" error, then there is a troubleshooting guide in BOL. Most likely it is a security problem.

Thanks,

Mark

|||Hi,

Thanks for the reply. I don't think I need quorum because I am not

using a witness server. The first error message I get after I click on

start mirroring on the wizard is this

"The server network address "TCP://NDIVERSBK:5022" can not be reached

or does not exist. Check the network address name and reissue the

command. (Microsoft SQL Server, Error: 1418)"

I can configure security without any problem and it creates the end

points on both the servers also but I get an error when I click on

start mirroring.

When I click OK and clcik on start mirroing again I get this error message "Neither

the partner nor the witness server instance for database "shop" is

available. Reissue the command when at least one of the instances

becomes available. (Microsoft SQL Server, Error: 1431)".

Both servers are using the same service account and have the same sa

and administrator passwords. They are on the same network and workgroup

but not on a a domain.

The steps I took to setup mirroring was:

1. Setup the SQL service to run on windows account with administrator

permissions and had the same account password on both the servers.

2. Added -T1400 as starup parameter on both servers and restarted them.

3. Backed up the database on the principal server and restored the it on the mirror server using no recovery mode.

4. Backed up a transaction log on primary server and restored it again on mirror in no-recovery mode.

5. Started mirroing wizard using on prinicipal server and cliked the configure secuirty button.

6. Selected only principal and mirror server and no witness server.

7. Set the principal and mirror server instance using the

same endpoint name and listener port and select encrypt data.

8. Left the service accounts principal and mirror blank

9. It created the end points on both servers and we checked

to make sure they are there.

10 Clicked on start mirroring and that’s when we got the

error that it cannot find mirror server first time.

When we clicked OK and clicked on start mirroring again we

got the second error and always shows up and is mentioned above.
We also tried using the sql queries and got the same

error.|||

Excellent repro steps!

OK, 1418 was one of the most mentioned errors that database mirroring had, and so I went and created a specific Books OnLine topic for it. If you search for "troubleshooting database mirroring" in BOL, then you should find the section.

If you have configured SQL to use the SA accounts (like you state you do), then my next guess is that the port is blocked by a firewall. Basically, the first error message (1418)means the principal cannot access the mirror. Then you connect to the mirror, but since it has never talked with the principal, the mirror does not know what state the session is in, and so it returns the 1431 error.

To verify that the endpoint is accessable, open up a command windows and type "telnet NDIVERSBK 5022". If the endpoint is working properly, then the screen should clear, and you should be able to make 16 keystrokes before the connection is terminated. If you can't do that, the port is probably blocked. If you can do that, we'll start looking in the errorlog files.

Thanks,

Mark

|||There is no firewall between the servers and I tried opening up a command windows and type "telnet NDIVERSBK 5022". The screen cleared, and I was able to make 16 keystrokes before the connection got terminated.

Thanks for your help.

|||

OK, the endpoints are waiting for connections...

Hmmmm...

If the endpoints are configured properly, and you can telnet into the endpoint from each server to the other server, then my guess is that the problem is security.

Could you send me the errorlogs from both servers that have the errors recorded in log?

Normally the errorlogs are in "Program Files\Microsoft SQL Server\MSSQL.n\MSSQL\LOG\ERRORLOG" by default.

mwistrom@.microsoft.com

Thanks,

Mark

|||I have emailed the log file to the email address you provided. Thanks.|||Can this be a problem for mirroring:

The database owner is sa and I am logging in as sa in Management

Studio. But when I click on Database diagrams I get the following error

"Database diagram support objects cannot be installed because this

database does not have a valid owner. To continue, first use the Files

page of the Database Properties dialog box or the ALTER AUTHORIZATION

statement to set the database owner to a valid login, then add the

database diagram support objects."|||

I also already tried FQDN using this line

Alter database db set partner = 'NDIVERSBK.dds.com:5022' and this also does

not work and I still get the same error.

When I try to telnet to NDIVERSBK.dds.com at port 5022 the blank black

screen stay only for a second and then goes without any keystrokes.

|||

Don't forget that the syntax is 'tcp://ndiversbk.dds.com:5022'

If the telnet kicks you out after 1 second, then there is a problem with security and the endpoint. It should let you type 16 keystrokes and then kick you out.

Did you specify the 1400 trace flag?

|||

Just try

drop endpoint [mirroring]

in both server and restart the process

[];s

Marcelo Glauco

Neither the partner nor the witness server instance for data...

I am getting this error while trying to setup mirroring.
"Neither the partner nor the witness server instance for database "shop" is available. Reissue the command when at least one of the instances becomes available. (Microsoft SQL Server, Error: 1431)"

I am just using principal and mirror server, there is no witness server. I have tried fully qualified name and ip for the servers also. I can connect from the principal server to the mirror server using the management studio and it also creates endpoints on prinicipal and witness. But then gives me an error that it cannot find the instance of the mirror server and if I try again it gives the error above. I can also telnet to port 5022.

I have used -T1400 as the startup parameter.

I did the backup and recovery based on this link http://msdn2.microsoft.com/en-us/library/ms189053.aspx and the mirror server is in recovery mode now.

Can you list the steps you followed when setting up mirroring?

Thanks,

Matt

|||

This error message indicates that the partner thinks that its database should be the principal database, but cannot open the database up because the server needs quorum.

Quorum is required to serve the database if the safety is set to FULL and the witness server has been set. This prevents "split brain". Right now the server doesn't know if the partner and witness have gone ahead and failed over the database to serve it, and so this server leaves its database offline.

If you are getting the "cannot find that server or the instance isn't started" error, then there is a troubleshooting guide in BOL. Most likely it is a security problem.

Thanks,

Mark

|||Hi,
Thanks for the reply. I don't think I need quorum because I am not using a witness server. The first error message I get after I click on start mirroring on the wizard is this
"The server network address "TCP://NDIVERSBK:5022" can not be reached or does not exist. Check the network address name and reissue the command. (Microsoft SQL Server, Error: 1418)"
I can configure security without any problem and it creates the end points on both the servers also but I get an error when I click on start mirroring.
When I click OK and clcik on start mirroing again I get this error message "Neither the partner nor the witness server instance for database "shop" is available. Reissue the command when at least one of the instances becomes available. (Microsoft SQL Server, Error: 1431)".
Both servers are using the same service account and have the same sa and administrator passwords. They are on the same network and workgroup but not on a a domain.
The steps I took to setup mirroring was:
1. Setup the SQL service to run on windows account with administrator permissions and had the same account password on both the servers.
2. Added -T1400 as starup parameter on both servers and restarted them.
3. Backed up the database on the principal server and restored the it on the mirror server using no recovery mode.
4. Backed up a transaction log on primary server and restored it again on mirror in no-recovery mode.
5. Started mirroing wizard using on prinicipal server and cliked the configure secuirty button.
6. Selected only principal and mirror server and no witness server.
7. Set the principal and mirror server instance using the same endpoint name and listener port and select encrypt data.
8. Left the service accounts principal and mirror blank
9. It created the end points on both servers and we checked to make sure they are there.
10 Clicked on start mirroring and that’s when we got the error that it cannot find mirror server first time.
When we clicked OK and clicked on start mirroring again we got the second error and always shows up and is mentioned above.
We also tried using the sql queries and got the same error.
|||

Excellent repro steps!

OK, 1418 was one of the most mentioned errors that database mirroring had, and so I went and created a specific Books OnLine topic for it. If you search for "troubleshooting database mirroring" in BOL, then you should find the section.

If you have configured SQL to use the SA accounts (like you state you do), then my next guess is that the port is blocked by a firewall. Basically, the first error message (1418)means the principal cannot access the mirror. Then you connect to the mirror, but since it has never talked with the principal, the mirror does not know what state the session is in, and so it returns the 1431 error.

To verify that the endpoint is accessable, open up a command windows and type "telnet NDIVERSBK 5022". If the endpoint is working properly, then the screen should clear, and you should be able to make 16 keystrokes before the connection is terminated. If you can't do that, the port is probably blocked. If you can do that, we'll start looking in the errorlog files.

Thanks,

Mark

|||There is no firewall between the servers and I tried opening up a command windows and type "telnet NDIVERSBK 5022". The screen cleared, and I was able to make 16 keystrokes before the connection got terminated.
Thanks for your help.
|||

OK, the endpoints are waiting for connections...

Hmmmm...

If the endpoints are configured properly, and you can telnet into the endpoint from each server to the other server, then my guess is that the problem is security.

Could you send me the errorlogs from both servers that have the errors recorded in log?

Normally the errorlogs are in "Program Files\Microsoft SQL Server\MSSQL.n\MSSQL\LOG\ERRORLOG" by default.

mwistrom@.microsoft.com

Thanks,

Mark

|||I have emailed the log file to the email address you provided. Thanks.
|||Can this be a problem for mirroring:
The database owner is sa and I am logging in as sa in Management Studio. But when I click on Database diagrams I get the following error
"Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION statement to set the database owner to a valid login, then add the database diagram support objects."
|||

I also already tried FQDN using this line

Alter database db set partner = 'NDIVERSBK.dds.com:5022' and this also does not work and I still get the same error.

When I try to telnet to NDIVERSBK.dds.com at port 5022 the blank black screen stay only for a second and then goes without any keystrokes.

|||

Don't forget that the syntax is 'tcp://ndiversbk.dds.com:5022'

If the telnet kicks you out after 1 second, then there is a problem with security and the endpoint. It should let you type 16 keystrokes and then kick you out.

Did you specify the 1400 trace flag?

|||

Just try

drop endpoint [mirroring]

in both server and restart the process

[];s

Marcelo Glauco

NEEDED: SQL Server Express 2005 Setup Walkthrough

Someone please help me, Im trying to set up SQLServer on my website(IIS v4.0) and I cant seem to get any web apps that use SQL to intall correctly, I get errors like, SQL does not recieve remote connections by default, or just 'Server Not Found'.

This is what I need to know

- How to set SQL to accept incomming remote connections

- Where to find the Name of the SQL instance

- Is it a good idea to have a password on the db, and how do I add one

- A walkthrough on how to set up SQL Express 2005(what to do after the istall is complete)

As you can see Im very new to SQL. So any information you could give to help would be greatly appreciated.

Thanks

Admin @. Something-to-do.com

1. Here is a KB Article that goes through setting up remote connections. http://support.microsoft.com/kb/914277

2. With SQL Server 2005 Express the server install defaults to ".\SQLEXPRESS" for the instance. To find the name though you can check the windows service list in the Services mmc inside the administration folder under the control panel. The name will be inside brackets beside the SQL Server Service.

3. You should try and stay with Windows Logons for the security.. if you do need to use sql logons you should try a strong password on the database accounts.

Need your assistance

Hi,
I need your assistance with 2 questions:
1. I just got my new server and ready to setup as my warehouse (Data). It's
has 2 logical drives:
a. C: at 31GB
b. D: at 260GB
I installed SQL Server 2000 Analysis Server successfully. How can I move the
data to be stored on the 260GB drive?
2. My second question is: When I delete a cube I don't see my drive space
being recovered. How can I recover the drive space?
Thanksto move user databases (not system database like msdb, master, tempdb)
simply detach the database, move the MDF and LDF files to the D: then attach
the database from the new location.
read this:
http://support.microsoft.com/kb/224071/en-us
for AS, what are the size of your cubes? (sometimes the cubes are small so
you don't see the difference)
if you delete in the management interface and the data folder still contain
the deleted objects, you can delete the folder yourself.
but take care to delete ONLY the folder with the deleted objects
but...
BACKUP BACKUP BACKUP !!!!!
backup before you do anything a mistake can break everything.
"Chris" <Chris@.discussions.microsoft.com> wrote in message
news:F3A8F622-9120-4FA1-B240-B2F051AFFB60@.microsoft.com...
> Hi,
> I need your assistance with 2 questions:
> 1. I just got my new server and ready to setup as my warehouse (Data).
> It's
> has 2 logical drives:
> a. C: at 31GB
> b. D: at 260GB
> I installed SQL Server 2000 Analysis Server successfully. How can I move
> the
> data to be stored on the 260GB drive?
> 2. My second question is: When I delete a cube I don't see my drive space
> being recovered. How can I recover the drive space?
> Thanks|||I think Chris was asking how he can move his AS2000 Data to the D partition?
If so, then you should specify this at the point of installation.
You have the option to specify the data location during both SQL and AS
installation.
Immy
"Chris" <Chris@.discussions.microsoft.com> wrote in message
news:F3A8F622-9120-4FA1-B240-B2F051AFFB60@.microsoft.com...
> Hi,
> I need your assistance with 2 questions:
> 1. I just got my new server and ready to setup as my warehouse (Data).
> It's
> has 2 logical drives:
> a. C: at 31GB
> b. D: at 260GB
> I installed SQL Server 2000 Analysis Server successfully. How can I move
> the
> data to be stored on the 260GB drive?
> 2. My second question is: When I delete a cube I don't see my drive space
> being recovered. How can I recover the drive space?
> Thanks|||Hello Immy
You can specify the location databases and cubes after installation of
SQL 2000.
Try this for changing the location of AS2000 data:
1. Select the Analysis Services Server in Analysis Manager
2. Right click and on the server icon select Properties
3. Under the general tab you can specify the location for the Analysis
Services Cube location.
Like wise you can also try the same steps for default location of SQL
Server User databases.
For existing SQL database follow Jeje's post. Its also important to
note that you can specify the location of you SQL database in both
T-SQL and Enterprise Manager.
Hope this Helps,
Myles Matheson
Data Warehouse Architect
http://bi-on-sql-server.blogspot.com/|||Since I am on this, I have read somewhere that for performance isues (IO) it
is recommended to put the data files and system databases on different
spindles. My question:
If I am using Raid 5 how can I achieve separate spindles? Isn't Raid 5 using
multiples drives as one or more logical drive which does not guarentee a
separate spindle?
Thanks
"Myles.Matheson@.gmail.com" wrote:

> Hello Immy
> You can specify the location databases and cubes after installation of
> SQL 2000.
> Try this for changing the location of AS2000 data:
> 1. Select the Analysis Services Server in Analysis Manager
> 2. Right click and on the server icon select Properties
> 3. Under the general tab you can specify the location for the Analysis
> Services Cube location.
> Like wise you can also try the same steps for default location of SQL
> Server User databases.
> For existing SQL database follow Jeje's post. Its also important to
> note that you can specify the location of you SQL database in both
> T-SQL and Enterprise Manager.
> Hope this Helps,
> Myles Matheson
> Data Warehouse Architect
> http://bi-on-sql-server.blogspot.com/
>