Registering Error: registration

Showing posts with label registration. Show all posts

Wednesday, March 7, 2012

Registration Problem

I tried to Register the SQL Express. I received the Email to comfirmation and verification but I don't received Any Key!

Can some one help me?

Thanks

Actually you don′t need to register within SQL Server Express, this will bring you only additional benefits like information about updates and other news about SQL Server (and as far as I can remeber some benefits), but since SQL Server Express is free you don′t even need to register nor need a license code.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||

Jens is correct, no key is needed. We do like people to register though; the registration process offers some benefits as well as the option to get updates about patches, etc. Registration also allows us to better understand how people are using SQL Express (there are a few questions), which helps me do a better job designing the next version of SQL Express.

Mike

|||

Is there a evaluation copy for SQL2005/ Reporting Server 2005? How Can we verify if we have installed a trial version? And how can this be permanetly activated?

Prasanna

vvprasanna@.yahoo.com

|||

Yes there is a trial version: http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=6931fa7f-c094-49a2-a050-2d07993566ec

Refer to the following snippet from the MS site:

Upgrading and Uninstalling the Trial Software

The 180-day trial version of SQL Server 2005 Enterprise Edition can be upgraded to the fully licensed version of SQL Server 2005 Enterprise Edition without uninstalling the trial software prior to the end of the 180-day period. If upgrading to the fully licensed version of SQL Server 2005 Standard Edition, Workgroup Edition, or Developer Edition, it is recommended that you uninstall the 180-day trial version of SQL Server 2005 Enterprise Edition before installing the fully licensed version of the other editions. Please refer to the product documentation for information about upgrading to the fully licensed software.

http://www.microsoft.com/sql/downloads/trial-system-requirements.mspx

If you want to upgrade the product you should do that before the trial period has ended to avoid problems like this:
http://support.microsoft.com/kb/914158/en-us

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

It's also worth noting that SQL Express with Advanced Services includes Reporting Services free of charge. There are some limitation as is common with free products, but it might meet you needs. Check out the feature comparison by Edition.

Mike

Registration of SQL with WEB Server

i need to know how can i register my SQL server with WEb based SQL server

i have the address MSSQL2.MINUTESUAE.COM now how can i register my SQL Server with them.

when i m going to conect with this server it register but after that Database not show it take to much time.

Hi,

If you are trying to connect a shared database supplied by a hosting firm, to see your database in your Enterprise Manager will take really so long time.

I can advise you to connect your database by using Query Analyzer not Enterprise Manager.

You will connect your database directly if you use Query Analyzer.

Eralper

http://www.kodyaz.com

Registration of SQL Servers missing in Enterprise manager

Hi All,
Recently a strange behaviour was seen with Enterprise manager. When we
change the Windows login password all the registrations of SQL Servers are
missing from SQL Server Enterprise Manager. Did anyone faced this situation
before? Its really painful to register 20 servers each time when login
password is changed. Some of the registered servers are windows
authentication and rest of them are SQL Server authentication.
Thanks a lot in advance!
Vinod MeesalaHi,
Never aware of this issues. What is the SQL Server service pack you are using?
If you are using old service packs, install SP4 for SQL 2000 (if you are
using SQL Server 2000) and see if you still have issues.
Thanks
Hari
SQL Server MVP
"VM" wrote:
> Hi All,
> Recently a strange behaviour was seen with Enterprise manager. When we
> change the Windows login password all the registrations of SQL Servers are
> missing from SQL Server Enterprise Manager. Did anyone faced this situation
> before? Its really painful to register 20 servers each time when login
> password is changed. Some of the registered servers are windows
> authentication and rest of them are SQL Server authentication.
> Thanks a lot in advance!
> Vinod Meesala|||Sounds like this may be the issue you are running into:
FIX: Registered remote servers disappear from SQL Enterprise
Manager in Windows XP when user password is changed
http://support.microsoft.com/?id=323280
-Sue
On Thu, 17 Aug 2006 13:39:02 -0700, VM
<VM@.discussions.microsoft.com> wrote:
>Hi All,
>Recently a strange behaviour was seen with Enterprise manager. When we
>change the Windows login password all the registrations of SQL Servers are
>missing from SQL Server Enterprise Manager. Did anyone faced this situation
>before? Its really painful to register 20 servers each time when login
>password is changed. Some of the registered servers are windows
>authentication and rest of them are SQL Server authentication.
>Thanks a lot in advance!
>Vinod Meesala|||Sue,
Thats an awsome piece of information. I wasn't aware of this.
Thanks
Hari
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:04s9e214f3pk9386bmg12lq7jq8q4kbqhj@.4ax.com...
> Sounds like this may be the issue you are running into:
> FIX: Registered remote servers disappear from SQL Enterprise
> Manager in Windows XP when user password is changed
> http://support.microsoft.com/?id=323280
> -Sue
> On Thu, 17 Aug 2006 13:39:02 -0700, VM
> <VM@.discussions.microsoft.com> wrote:
>>Hi All,
>>Recently a strange behaviour was seen with Enterprise manager. When we
>>change the Windows login password all the registrations of SQL Servers are
>>missing from SQL Server Enterprise Manager. Did anyone faced this
>>situation
>>before? Its really painful to register 20 servers each time when login
>>password is changed. Some of the registered servers are windows
>>authentication and rest of them are SQL Server authentication.
>>Thanks a lot in advance!
>>Vinod Meesala
>|||Hey Hari,
People haven't hit the issue for quite awhile so you
probably just forgot it by now. I think it was two or three
years ago when people posted hitting the issue. I guess I'm
just wasting limited brain space with old info - your brain
is just more current than mine : )
-Sue
On Thu, 17 Aug 2006 19:00:43 -0500, "Hari Prasad"
<hari_prasad_k@.hotmail.com> wrote:
>Sue,
>Thats an awsome piece of information. I wasn't aware of this.
>Thanks
>Hari
>"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
>news:04s9e214f3pk9386bmg12lq7jq8q4kbqhj@.4ax.com...
>> Sounds like this may be the issue you are running into:
>> FIX: Registered remote servers disappear from SQL Enterprise
>> Manager in Windows XP when user password is changed
>> http://support.microsoft.com/?id=323280
>> -Sue
>> On Thu, 17 Aug 2006 13:39:02 -0700, VM
>> <VM@.discussions.microsoft.com> wrote:
>>Hi All,
>>Recently a strange behaviour was seen with Enterprise manager. When we
>>change the Windows login password all the registrations of SQL Servers are
>>missing from SQL Server Enterprise Manager. Did anyone faced this
>>situation
>>before? Its really painful to register 20 servers each time when login
>>password is changed. Some of the registered servers are windows
>>authentication and rest of them are SQL Server authentication.
>>Thanks a lot in advance!
>>Vinod Meesala
>|||Excellent Finding!! Thanks much Sue! I will try this Fix.
Vinod Meesala
"Sue Hoegemeier" wrote:
> Sounds like this may be the issue you are running into:
> FIX: Registered remote servers disappear from SQL Enterprise
> Manager in Windows XP when user password is changed
> http://support.microsoft.com/?id=323280
> -Sue
> On Thu, 17 Aug 2006 13:39:02 -0700, VM
> <VM@.discussions.microsoft.com> wrote:
> >Hi All,
> >
> >Recently a strange behaviour was seen with Enterprise manager. When we
> >change the Windows login password all the registrations of SQL Servers are
> >missing from SQL Server Enterprise Manager. Did anyone faced this situation
> >before? Its really painful to register 20 servers each time when login
> >password is changed. Some of the registered servers are windows
> >authentication and rest of them are SQL Server authentication.
> >
> >Thanks a lot in advance!
> >
> >Vinod Meesala
>

Registration of SQL Server

Helo All,
We have two W2K servers. One is an SQL Server(S1) and another one is a
server (S2) on which SSL Certificate is installed.
When I try to register SQL Server from S2 through enterprises manager,
following error occured:
Encryption not supported on SQL Server| ConnectionOpen(PreLoginHandshake...
In this scenario is it mandatory to have SSL installed on the SQL Server
Machine (S1) also?
Any comment on this would be highly helpful.
Thanks in anticipation!
Warm Regards
Sathian>
> We have two W2K servers. One is an SQL Server(S1) and another one is a
> server (S2) on which SSL Certificate is installed.
> When I try to register SQL Server from S2 through enterprises manager,
> following error occured:
> Encryption not supported on SQL Server|
ConnectionOpen(PreLoginHandshake...
> In this scenario is it mandatory to have SSL installed on the SQL Server
> Machine (S1) also?
> Any comment on this would be highly helpful.
--
This error indicates either sql server server thinks the certificate is
invalid
or can't locate the certificate. To check if Sql Server can use a
certificate, enable
force protocol encryption on the server side and restart the service. If
Sql Server starts then certificate is okay.
The error can also occur if you have installed the certificate on sql
server but
have not restarted sql. so even if you are using client side encryption,
you need to restart sql server once the certificate is installed.
Hope this helps,
--
Eric Cárdenas
Senior support professional
This posting is provided "AS IS" with no warranties, and confers no rights.

Registration of SQL Server

Helo All,
We have two W2K servers. One is an SQL Server(S1) and another one is a
server (S2) on which SSL Certificate is installed.
When I try to register SQL Server from S2 through enterprises manager,
following error occured:
Encryption not supported on SQL Server| ConnectionOpen(PreLoginHandshake...
In this scenario is it mandatory to have SSL installed on the SQL Server
Machine (S1) also?
Any comment on this would be highly helpful.
Thanks in anticipation!
Warm Regards
Sathian
>
> We have two W2K servers. One is an SQL Server(S1) and another one is a
> server (S2) on which SSL Certificate is installed.
> When I try to register SQL Server from S2 through enterprises manager,
> following error occured:
> Encryption not supported on SQL Server|
ConnectionOpen(PreLoginHandshake...
> In this scenario is it mandatory to have SSL installed on the SQL Server
> Machine (S1) also?
> Any comment on this would be highly helpful.
This error indicates either sql server server thinks the certificate is
invalid
or can't locate the certificate. To check if Sql Server can use a
certificate, enable
force protocol encryption on the server side and restart the service. If
Sql Server starts then certificate is okay.
The error can also occur if you have installed the certificate on sql
server but
have not restarted sql. so even if you are using client side encryption,
you need to restart sql server once the certificate is installed.
Hope this helps,
Eric Crdenas
Senior support professional
This posting is provided "AS IS" with no warranties, and confers no rights.

Registration of mobile data provider for SQLCE

Hi All,
I have just installed SQL Server Compact Edition (including the SDK) for use with Borland Developer Studio 2006. I have an ADOConnection component on my form, but the Provider I want (Microsoft.SQLSERVER.MOBILE.OLEDB.3.0) is not available. Typing in the connection string: "Provider=Microsoft.SQLSERVER.MOBILE.OLEDB.3.0;Data Source=C:\Program Files\Microsoft SQL Server Compact Edition\v3.1\SDK\Samples\Northwind.sdf..." results in an "Unspecified Error". I have checked the HKEY_CLASSES_ROOT\CLSID and the provider associated with SQLCE is not there.
I've read a couple of posts indicating that it should have been registered during install. Is this the case or do I have to do something more to register this provider?
I've checked the assembly (system.data.sqlserverCe - it seems OK) and re-registered sqlceolebd30.dll. I'm not sure what else needs to be done.
TIA,
Luke
Have you downloaded and installed this? http://www.microsoft.com/downloads/details.aspx?FamilyId=%2085E0C3CE-3FA1-453A-8CE9-AF6CA20946C3&displaylang=en|||Thanks for you reply Erik.
I have downloaded that msi, along with the SSCE31SDK-ENU.msi.
On the link that you specified the Additional Information states in part that " Installing SQL Server 2005 Compact Edition by running SQLServerCE31-EN.msi installs the provider (System.Data.SqlServerCe.dll) in the GAC (global assembly cache) and registers the OLEDB provider (sqlceoledb30.dll)."
For some reason that hasn't happened. I'll look into some other way of registering the provider.
Thanks again.
|||

You can test if it is an OLEDB provider problem by running this VBA code in Excel/word or similar:

Code Snippet

Sub test()

Dim conn As New ADODB.Connection
conn.ConnectionString = "Provider=Microsoft.SQLSERVER.MOBILE.OLEDB.3.0;Data Source=C:\Program Files\Microsoft SQL Server Compact Edition\v3.1\SDK\Samples\Northwind.sdf"
conn.Open

End Sub

(remember to add a reference to "Microsoft ActiveX Data Objects 2.8 Library")

If this works, it is a 3rd party problem...

|||Thanks Erik. I tried that in Excel and it worked so I figured it must be Delphi related, and it was.
For some reason I am not able to hook up the ADO components at design time - it raises an error. If I set the connection string at run time it works. I tried this yesterday with no luck, but this morning I uninstalled/reinstalled SQL Server Compact (with SDK and server tools) and the run time test worked, so I may well have done something with my original install that was causing me problems.

Registration of CLR-function sample fails

I'm trying to reproduce the VB CLR sample concat function from the SQL documentation (ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/denet9/html/5a188b50-7170-4069-acad-5de5c915f65d.htm)

I've installed Visual Studio 2005 and compiled the DLL which seems to work fine, but when I try to register the DLL with this call:

create assembly sqlfuncdll from 'D:\SQLdata\dll\SQLfunctions.dll'

I got this error:

Msg 10301, Level 16, State 1, Line 1

Assembly 'SQLfunctions' references assembly 'system.windows.forms, version=2.0.0.0, culture=neutral, publickeytoken=b77a5c561934e089.', which is not present in the current database. SQL Server attempted to locate and automatically load the referenced assembly from the same location where referring assembly came from, but that operation has failed (reason: 2(The system cannot find the file specified.)). Please load the referenced assembly into the current database and retry your request.

When I remove the system.windows.form reference from the VB project (my suggestion is : I don't need the forms) then the project won't builld, so somehow it needs it.

What sould I do to get this DLL working?

hans

What type of Visual Studio project are you using? If you make a class library rather than a Windows Forms application then just the code in the documentation alone should compile fine without the reference.

--Bonnie

|||

The application type of the project is indeed "Class Library".

When I remove the System.Windows.Forms reference from the project, then the compilation of the DLL fails, I don't get any error message why, it just don't work. When I put the reference back, then the compilation is succesfull. I can't get why it needs this reference.

Some how I should get this project working without the System.Windows.Forms reference, because in the SQL documentation I found that this library is not supported and not linked by default :

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

I started the VB project from scratch and now it does not need the System.Windows.Forms reference I don't understand why, but some how this reference was needed.

|||Most people make the mistake that they want to use MessageBox.Show in their Assemblies, which is sure not supported by the SQL CLR. If you are not sure which command is preventing you from registering the assembly, send the code over and we / I will have a look on it.

Jens K. Suessmeyer.

http://www.sqlserver2005.de

Registration from Enterprise Manager

Here is my problem:
I have a sqlserver SQLA which I have registered in EM with a sqlserver
authentication with a uid and password and that connection works fine. The
problem is that when I look at the security log of SQLA, i see continuous
failure audits but with a uid that I am logging in to my local machine with.
My question is that when I am choosing to use sqlserver authentication and
not windows authentication to connect to SQLA, how come it is in turn still
sending windows authentication requests at the same time.
Few thing that have led me to this is:
1.When I delete the sqlserver registration from EM, those failure audits
stop, so that nakes me sure that these are coming from EM only.
2. When I map a drive to SQLA with windows credentials, these failure audits
stop, which indicates that it is succeeding in windows authentication ,
thats why the audits stop.
Please let me know your thoughts?
What you are seeing is probably related to the polling that Enterprise
Manager does - it polls the SQL and related services on the servers
that you have registered. You can turn this off in Enterprise Manager
by going up to the menu to Tools and selecting Options. On the general
tab, you can remove the check for Server State Polling.
-Sue
On Fri, 10 Sep 2004 15:44:06 GMT, "Renu Doda" <r_doda@.hotmail.com>
wrote:

>Here is my problem:
>I have a sqlserver SQLA which I have registered in EM with a sqlserver
>authentication with a uid and password and that connection works fine. The
>problem is that when I look at the security log of SQLA, i see continuous
>failure audits but with a uid that I am logging in to my local machine with.
>My question is that when I am choosing to use sqlserver authentication and
>not windows authentication to connect to SQLA, how come it is in turn still
>sending windows authentication requests at the same time.
>Few thing that have led me to this is:
>1.When I delete the sqlserver registration from EM, those failure audits
>stop, so that nakes me sure that these are coming from EM only.
>2. When I map a drive to SQLA with windows credentials, these failure audits
>stop, which indicates that it is succeeding in windows authentication ,
>thats why the audits stop.
>Please let me know your thoughts?
>

Registration form problem. String or binary data would be truncated

I have created a registration form. It works fine IF ALL fields are filled. However, all fields are not required. When I test the registration page and leave a field blank, I receive the following message:

Exception Details: System.Data.SqlClient.SqlException: String or binary data would be truncated. The statement has been terminated.

Stack Trace:

[SqlException: String or binary data would be truncated.
The statement has been terminated.]

Even if I leave a validated field blank, I receive the same message instead of the required field validation control error message.

Here is the code for the registration page. I use web matrix to create the code as directed in the tutorial.

Can anyone help a newbie?

Function AddMember( _
ByVal firstName As String, _
ByVal lastName As String, _
ByVal streetAddress1 As String, _
ByVal streetAddress2 As String, _
ByVal memCity As String, _
ByVal state As String, _
ByVal zipCode As String, _
ByVal primAreaCode As String, _
ByVal primPhone As String, _
ByVal primExt As String, _
ByVal secAreaCode As String, _
ByVal secPhone As String, _
ByVal secExt As String, _
ByVal memEmail As String, _
ByVal memUserID As String, _
ByVal memPassword As String, _
ByVal secretQuestion As String, _
ByVal secretAnswer As String, _
ByVal memBirthMonth As String, _
ByVal memBirthDay As String, _
ByVal memBirthYear As String) As Integer
Dim connectionString As String = "server='(local)'; trusted_connection=true; database='Members'"
Dim dbConnection As System.Data.IDbConnection = New System.Data.SqlClient.SqlConnection(connectionString)

Dim queryString As String = "INSERT INTO [Members] ([FirstName], [LastName], [StreetAddress1], [StreetAddress2"& _
"], [MemCity], [State], [ZipCode], [PrimAreaCode], [PrimPhone], [PrimExt], [SecAr"& _
"eaCode], [SecPhone], [SecExt], [MemEmail], [MemUserID], [MemPassword], [SecretQu"& _
"estion], [SecretAnswer], [MemBirthMonth], [MemBirthDay], [MemBirthYear]) VALUES "& _
"(@.FirstName, @.LastName, @.StreetAddress1, @.StreetAddress2, @.MemCity, @.State, @.Zip"& _
"Code, @.PrimAreaCode, @.PrimPhone, @.PrimExt, @.SecAreaCode, @.SecPhone, @.SecExt, @.Me"& _
"mEmail, @.MemUserID, @.MemPassword, @.SecretQuestion, @.SecretAnswer, @.MemBirthMonth"& _
", @.MemBirthDay, @.MemBirthYear)"
Dim dbCommand As System.Data.IDbCommand = New System.Data.SqlClient.SqlCommand
dbCommand.CommandText = queryString
dbCommand.Connection = dbConnection

Dim dbParam_firstName As System.Data.IDataParameter = New System.Data.SqlClient.SqlParameter
dbParam_firstName.ParameterName = "@.FirstName"
dbParam_firstName.Value = firstName
dbParam_firstName.DbType = System.Data.DbType.String
dbCommand.Parameters.Add(dbParam_firstName)
Dim dbParam_lastName As System.Data.IDataParameter = New System.Data.SqlClient.SqlParameter
dbParam_lastName.ParameterName = "@.LastName"
dbParam_lastName.Value = lastName
dbParam_lastName.DbType = System.Data.DbType.String
dbCommand.Parameters.Add(dbParam_lastName)
Dim dbParam_streetAddress1 As System.Data.IDataParameter = New System.Data.SqlClient.SqlParameter
dbParam_streetAddress1.ParameterName = "@.StreetAddress1"
dbParam_streetAddress1.Value = streetAddress1
dbParam_streetAddress1.DbType = System.Data.DbType.String
dbCommand.Parameters.Add(dbParam_streetAddress1)
Dim dbParam_streetAddress2 As System.Data.IDataParameter = New System.Data.SqlClient.SqlParameter
dbParam_streetAddress2.ParameterName = "@.StreetAddress2"
dbParam_streetAddress2.Value = streetAddress2
dbParam_streetAddress2.DbType = System.Data.DbType.String
dbCommand.Parameters.Add(dbParam_streetAddress2)
Dim dbParam_memCity As System.Data.IDataParameter = New System.Data.SqlClient.SqlParameter
dbParam_memCity.ParameterName = "@.MemCity"
dbParam_memCity.Value = memCity
dbParam_memCity.DbType = System.Data.DbType.String
dbCommand.Parameters.Add(dbParam_memCity)
Dim dbParam_state As System.Data.IDataParameter = New System.Data.SqlClient.SqlParameter
dbParam_state.ParameterName = "@.State"
dbParam_state.Value = state
dbParam_state.DbType = System.Data.DbType.String
dbCommand.Parameters.Add(dbParam_state)
Dim dbParam_zipCode As System.Data.IDataParameter = New System.Data.SqlClient.SqlParameter
dbParam_zipCode.ParameterName = "@.ZipCode"
dbParam_zipCode.Value = zipCode
dbParam_zipCode.DbType = System.Data.DbType.String
dbCommand.Parameters.Add(dbParam_zipCode)
Dim dbParam_primAreaCode As System.Data.IDataParameter = New System.Data.SqlClient.SqlParameter
dbParam_primAreaCode.ParameterName = "@.PrimAreaCode"
dbParam_primAreaCode.Value = primAreaCode
dbParam_primAreaCode.DbType = System.Data.DbType.String
dbCommand.Parameters.Add(dbParam_primAreaCode)
Dim dbParam_primPhone As System.Data.IDataParameter = New System.Data.SqlClient.SqlParameter
dbParam_primPhone.ParameterName = "@.PrimPhone"
dbParam_primPhone.Value = primPhone
dbParam_primPhone.DbType = System.Data.DbType.String
dbCommand.Parameters.Add(dbParam_primPhone)
Dim dbParam_primExt As System.Data.IDataParameter = New System.Data.SqlClient.SqlParameter
dbParam_primExt.ParameterName = "@.PrimExt"
dbParam_primExt.Value = primExt
dbParam_primExt.DbType = System.Data.DbType.String
dbCommand.Parameters.Add(dbParam_primExt)
Dim dbParam_secAreaCode As System.Data.IDataParameter = New System.Data.SqlClient.SqlParameter
dbParam_secAreaCode.ParameterName = "@.SecAreaCode"
dbParam_secAreaCode.Value = secAreaCode
dbParam_secAreaCode.DbType = System.Data.DbType.String
dbCommand.Parameters.Add(dbParam_secAreaCode)
Dim dbParam_secPhone As System.Data.IDataParameter = New System.Data.SqlClient.SqlParameter
dbParam_secPhone.ParameterName = "@.SecPhone"
dbParam_secPhone.Value = secPhone
dbParam_secPhone.DbType = System.Data.DbType.String
dbCommand.Parameters.Add(dbParam_secPhone)
Dim dbParam_secExt As System.Data.IDataParameter = New System.Data.SqlClient.SqlParameter
dbParam_secExt.ParameterName = "@.SecExt"
dbParam_secExt.Value = secExt
dbParam_secExt.DbType = System.Data.DbType.String
dbCommand.Parameters.Add(dbParam_secExt)
Dim dbParam_memEmail As System.Data.IDataParameter = New System.Data.SqlClient.SqlParameter
dbParam_memEmail.ParameterName = "@.MemEmail"
dbParam_memEmail.Value = memEmail
dbParam_memEmail.DbType = System.Data.DbType.String
dbCommand.Parameters.Add(dbParam_memEmail)
Dim dbParam_memUserID As System.Data.IDataParameter = New System.Data.SqlClient.SqlParameter
dbParam_memUserID.ParameterName = "@.MemUserID"
dbParam_memUserID.Value = memUserID
dbParam_memUserID.DbType = System.Data.DbType.String
dbCommand.Parameters.Add(dbParam_memUserID)
Dim dbParam_memPassword As System.Data.IDataParameter = New System.Data.SqlClient.SqlParameter
dbParam_memPassword.ParameterName = "@.MemPassword"
dbParam_memPassword.Value = memPassword
dbParam_memPassword.DbType = System.Data.DbType.String
dbCommand.Parameters.Add(dbParam_memPassword)
Dim dbParam_secretQuestion As System.Data.IDataParameter = New System.Data.SqlClient.SqlParameter
dbParam_secretQuestion.ParameterName = "@.SecretQuestion"
dbParam_secretQuestion.Value = secretQuestion
dbParam_secretQuestion.DbType = System.Data.DbType.String
dbCommand.Parameters.Add(dbParam_secretQuestion)
Dim dbParam_secretAnswer As System.Data.IDataParameter = New System.Data.SqlClient.SqlParameter
dbParam_secretAnswer.ParameterName = "@.SecretAnswer"
dbParam_secretAnswer.Value = secretAnswer
dbParam_secretAnswer.DbType = System.Data.DbType.String
dbCommand.Parameters.Add(dbParam_secretAnswer)
Dim dbParam_memBirthMonth As System.Data.IDataParameter = New System.Data.SqlClient.SqlParameter
dbParam_memBirthMonth.ParameterName = "@.MemBirthMonth"
dbParam_memBirthMonth.Value = memBirthMonth
dbParam_memBirthMonth.DbType = System.Data.DbType.String
dbCommand.Parameters.Add(dbParam_memBirthMonth)
Dim dbParam_memBirthDay As System.Data.IDataParameter = New System.Data.SqlClient.SqlParameter
dbParam_memBirthDay.ParameterName = "@.MemBirthDay"
dbParam_memBirthDay.Value = memBirthDay
dbParam_memBirthDay.DbType = System.Data.DbType.String
dbCommand.Parameters.Add(dbParam_memBirthDay)
Dim dbParam_memBirthYear As System.Data.IDataParameter = New System.Data.SqlClient.SqlParameter
dbParam_memBirthYear.ParameterName = "@.MemBirthYear"
dbParam_memBirthYear.Value = memBirthYear
dbParam_memBirthYear.DbType = System.Data.DbType.String
dbCommand.Parameters.Add(dbParam_memBirthYear)

Dim rowsAffected As Integer = 0
dbConnection.Open
Try
rowsAffected = dbCommand.ExecuteNonQuery
Finally
dbConnection.Close
End Try

Return rowsAffected

End Function

Do u have all the fields in the table defined as "not null"?|||no. some fields allow nulls.

Saturday, February 25, 2012

Registration failure in Enterprise Manager

I am in Enterprise Manager on ComputerA, logged in as user xyz. I am
attempting to add a new SQL Server registration for the SQL Server on
ComputerB, using SQL Server authentication based on SQL Server login abc. Th
e
registration fails, stating that the SQL Server does not exist or access is
denied. The Security Event Log on ComputerB indicates a login failure to the
account xyz, which does not exist on ComputerB. Why is the registration
attempt trying to log into a non-existent Windows account when I have
requested SQL Server authentication? TIA...Sounds like it could be that it's trying to connect using
named pipes. Check the order of the protocols using the
client network utility and try setting TCP/IP as the first
protocol if it already isn't the first one listed.
Or use the client network utility and create a TCP/IP alias
to ComputerB on ComputerA
-Sue
On Tue, 5 Jul 2005 12:19:05 -0700, "Steve B."
<SteveB@.discussions.microsoft.com> wrote:

>I am in Enterprise Manager on ComputerA, logged in as user xyz. I am
>attempting to add a new SQL Server registration for the SQL Server on
>ComputerB, using SQL Server authentication based on SQL Server login abc. T
he
>registration fails, stating that the SQL Server does not exist or access is
>denied. The Security Event Log on ComputerB indicates a login failure to th
e
>account xyz, which does not exist on ComputerB. Why is the registration
>attempt trying to log into a non-existent Windows account when I have
>requested SQL Server authentication? TIA...|||Thanks for your reply. Per your suggestion, I changed the order of the
protocols listed in the Client Network Utility, and I had already tried
creating the TCP/IP alias for ComputerB, but I tried it again. All to no
avail... :-(
"Sue Hoegemeier" wrote:

> Sounds like it could be that it's trying to connect using
> named pipes. Check the order of the protocols using the
> client network utility and try setting TCP/IP as the first
> protocol if it already isn't the first one listed.
> Or use the client network utility and create a TCP/IP alias
> to ComputerB on ComputerA
> -Sue
> On Tue, 5 Jul 2005 12:19:05 -0700, "Steve B."
> <SteveB@.discussions.microsoft.com> wrote:
>
>|||I thought I'd close this loop, in case others might benefit. The problem was
resolved by creating synchronized accounts on ComputerA and ComputerB.
ComputerB is a W2K3 system, and it appears that account synchronization is
required on W2K3 even when you're using SQL Server authentication. So I
wonder why you'd ever bother with SQL Server authentication on W2K3?
"Steve B." wrote:
[vbcol=seagreen]
> Thanks for your reply. Per your suggestion, I changed the order of the
> protocols listed in the Client Network Utility, and I had already tried
> creating the TCP/IP alias for ComputerB, but I tried it again. All to no
> avail... :-(
> "Sue Hoegemeier" wrote:
>|||It's not a requirement. Synching the accounts and passwords
is in non-domain settings sometimes but it's to allow
Windows authentication. If you are specifying SQL
authentication and Windows is used instead then you have
something else that's a problem. You may want to check what
protocol you are actually connecting with - the net library
is listed in sysprocesses. You may also want to run
component check to verify your MDAC installation. You can
download it from:
http://msdn.microsoft.com/data/mdac...ds/default.aspx
-Sue
On Tue, 12 Jul 2005 08:44:05 -0700, "Steve B."
<SteveB@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>I thought I'd close this loop, in case others might benefit. The problem wa
s
>resolved by creating synchronized accounts on ComputerA and ComputerB.
>ComputerB is a W2K3 system, and it appears that account synchronization is
>required on W2K3 even when you're using SQL Server authentication. So I
>wonder why you'd ever bother with SQL Server authentication on W2K3?
>"Steve B." wrote:
>

Registration Fails

For years I've had a server registration using sql server auth set up...now it's failing...can't be found not suthed BS...

I can still see mu other boxes in sql mode, and otyhers in mixed, and I can still see my remote boxes in Ireland and Pennysylvania...we're in NJ..

The person next to me does the same thing, had to reboot, but was fine.

I get ice in the winter...

bizzare-o world.

Any ideas?

Never seen anything like it...

I do know that our tech group has been doing some pushes lately...but I checked my settings and they seem fine..but why would I be able to see everything else but this one instance?...are you registering by IP or DNS name? I know that when i've had problems between here and the great state of Maine I had to reregister using the servers IP.|||can you ping its ip? what does a trace do?|||DNS and I can ping it....|||are you able to ping it both by IP and DNS? (if you can't by DNS ya might try and register it by it's IP)...|||Just tried..I can ping by both...I'm gonna go over and bother the other guy who's connecting to see what's different...|||OK, it was suggested that I try an osql connection from dos...

fact is I already tried that...

BUT it is a great point...for some reason the error message are more helpful..it's like QA interferes with the message...

Then I said, what about bcp...and I got a message I never saw before

C:\>bcp northwind.dbo.orders out orders.txt -SNJROS1D15\NJROS1D151DEV -Usa -Ppwd

CTLIB Message: - L6/O8/S5/N3/5/0:ct_connect(): directory service layer: internal directory control layer error: Requested server name not found.

Establishing connection failed.

C:\>

I'm going to try bcp from another box from xp_cmdshell|||Have you installed a Sybase client recently?|||I have a Sybase client AND server running and have no prob.

Brett, did your nw guys push something on the client as well? Try odbcping (of course it'll fail, but try with different security switches) Also, did you happen to do anything in terms of aliasing experimentation? Or maybe in Server Network Configuration on the offending server (sounds like it's offending your intelligence, doesn't it?;)|||The few times I have seen BCP fail with a ct_connect error, it was a Sybase bcp attempting to talk to a MS SQL Server. The problem I always have is that Sybase adds itself to the beginning of the PATH environment variable, so you tend to get it first. I have no doubt you can force the two to get along. Probably only take a couple rolls of duct tape. Here is the error I get for trying to connect to no server:

bcp pubs..authors out auth.txt /Sgarbage /T

SQLState = 08001, NativeError = 17
Error = [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.
SQLState = 01000, NativeError = 53
Warning = [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()).|||Another possiblity would be hav eyou gotten a beta version of Windows XP SP2? Rumour has it that this will come with a built-in firewall that will block port 1433 by default.

http://www.microsoft.com/sql/techinfo/administration/2000/security/winxpsp2faq.asp

I think we will all be having to play around with this, before our desktop groups get the idea into their heads that they need to deploy this service pack overnight.|||Yup, you're right, I forgot about common utility names. And CTLIB is very suspicious in the content of your error...aka CTlib API, which is Sybase's new web.sql API. Are you screwing with Sybase, Brett?|||Yup installed sysbase months agao...

I like the combiniation of errors thing...yes I think our server ops pushed something last week...

Got the Alias thing to work with the ip address...

What bugs me is that my other NJ is ok..probably on an isolated domain, as well as PA and Ireland...but that doesn't explain PROD on the same network...|||Are you screwing with Sybase, Brett?

Hey, I bought her a drink...

sybase, oracle, db2, sql server....all the same...just a different dress...

Was looking at mySQL...now that's a wolfer...kinda like acess...and now that I say that is access an rdbms? It's definetley not client server...how about foxpro DBaseIII...man they're just to many of them...

which platform would you like to choose?

It's this gdamn network crap I hate...

EDIT: Does Mac have an RDBMS? :eek:|||I have had intermittent problems with Enterprise Mangler where the connection would timeout under TCP/IP, but would be fine under Named Pipes. I never found a rhyme or reason to it. See what happens when you change your default net library in the Client Network Utility. Pretty much reduced to groping at, er...grasping at straws here.|||EDIT: Does Mac have an RDBMS? :eek:

As a matter of fact...sort of. There is a product called 4th Dimension that is an Access-like application. I am not certain if there are any Mac servers to start with. There very well could be, though.|||My original protocal order was Pipes then TCP/IP...when I switched (to enable the alias so I could get some work done), and then tried the bcp in dos, I then get the standard not found. not authed bullshit message...|||As a matter of fact...sort of. There is a product called 4th Dimension that is an Access-like application. I am not certain if there are any Mac servers to start with. There very well could be, though.
Yes there are, they are referred to as Linux boxes ;)|||Anyone know where ODBCPING is located?

M$ says it ships with 6.5 and higher...can't find it...|||It's on the CD, you need to copy it from there into your BINN directory. Or, as an alternative, I can put it here, let me know.|||Thanks...all of the stuff is on a lan share..have to look...

That said...are you telling me it's not part of the install? I select everything...and then why isn't it available as a download from M$?

Registration error

Hi,
I am able to register other SQL server instances but when
I try to register one in particular I am getting this
error on the main server to which I need to register all
of the satelite servers. Can anyone help with this
problem? I don't understand why it is using a null
account instead of the guest account to try to log into
this particular instance.
Login failed for user '(null)'. Reason: Not associated
with a Trusted SQl Server connectionthat server is setup for Windows Authentication and you are logging in using
SQL login?
"Narine" <narinep@.siu.edu> wrote in message
news:2379e01c38c41$872a6010$a601280a@.phx.gbl...
> Hi,
> I am able to register other SQL server instances but when
> I try to register one in particular I am getting this
> error on the main server to which I need to register all
> of the satelite servers. Can anyone help with this
> problem? I don't understand why it is using a null
> account instead of the guest account to try to log into
> this particular instance.
>
> Login failed for user '(null)'. Reason: Not associated
> with a Trusted SQl Server connection|||I am just using windows authentication only because I am
using the datbase with MS VB.NET 2002 and I am doing
merge replication with subscribers.
>--Original Message--
>that server is setup for Windows Authentication and you
are logging in using
>SQL login?
>"Narine" <narinep@.siu.edu> wrote in message
>news:2379e01c38c41$872a6010$a601280a@.phx.gbl...
>> Hi,
>> I am able to register other SQL server instances but
when
>> I try to register one in particular I am getting this
>> error on the main server to which I need to register
all
>> of the satelite servers. Can anyone help with this
>> problem? I don't understand why it is using a null
>> account instead of the guest account to try to log into
>> this particular instance.
>>
>> Login failed for user '(null)'. Reason: Not associated
>> with a Trusted SQl Server connection
>
>.
>|||Check if the server you are trying to connect to is set to
Windows Authentication Only and change the security
settings to SQL Server and Windows. It seems that you are
using SQL authentication yourself and the other machine is
set to Windows Authentication only.
Edgardo Valdez
MCSD, MCDBA, MCSE, MCP+I
http://www.edgardovaldez.us/
>--Original Message--
>Hi,
>I am able to register other SQL server instances but when
>I try to register one in particular I am getting this
>error on the main server to which I need to register all
>of the satelite servers. Can anyone help with this
>problem? I don't understand why it is using a null
>account instead of the guest account to try to log into
>this particular instance.
>
>Login failed for user '(null)'. Reason: Not associated
>with a Trusted SQl Server connection
>.
>|||All of the servers are set to use Windows authentication
only originally when I installed them and this is stil so
when i just checked them. Could there be another reason
the main server is using the null account instead of the
guest account to register with the satelite server? How
can I set this parameter?
>--Original Message--
>Check if the server you are trying to connect to is set
to
>Windows Authentication Only and change the security
>settings to SQL Server and Windows. It seems that you
are
>using SQL authentication yourself and the other machine
is
>set to Windows Authentication only.
>
>Edgardo Valdez
>MCSD, MCDBA, MCSE, MCP+I
>http://www.edgardovaldez.us/
>>--Original Message--
>>Hi,
>>I am able to register other SQL server instances but
when
>>I try to register one in particular I am getting this
>>error on the main server to which I need to register
all
>>of the satelite servers. Can anyone help with this
>>problem? I don't understand why it is using a null
>>account instead of the guest account to try to log into
>>this particular instance.
>>
>>Login failed for user '(null)'. Reason: Not associated
>>with a Trusted SQl Server connection
>>.
>.
>|||Check this article and see if it applies to you:
http://support.microsoft.com/default.aspx?scid=kb;en-
us;Q279526
Edgardo Valdez
MCSD, MCDBA, MCSE, MCP+I
http://www.edgardovaldez.us/
>--Original Message--
>All of the servers are set to use Windows authentication
>only originally when I installed them and this is stil so
>when i just checked them. Could there be another reason
>the main server is using the null account instead of the
>guest account to register with the satelite server? How
>can I set this parameter?
>
>>--Original Message--
>>Check if the server you are trying to connect to is set
>to
>>Windows Authentication Only and change the security
>>settings to SQL Server and Windows. It seems that you
>are
>>using SQL authentication yourself and the other machine
>is
>>set to Windows Authentication only.
>>
>>Edgardo Valdez
>>MCSD, MCDBA, MCSE, MCP+I
>>http://www.edgardovaldez.us/
>>--Original Message--
>>Hi,
>>I am able to register other SQL server instances but
>when
>>I try to register one in particular I am getting this
>>error on the main server to which I need to register
>all
>>of the satelite servers. Can anyone help with this
>>problem? I don't understand why it is using a null
>>account instead of the guest account to try to log into
>>this particular instance.
>>
>>Login failed for user '(null)'. Reason: Not associated
>>with a Trusted SQl Server connection
>>.
>>.
>.
>|||I have installed SP3 for MSSQL server for the desktop and
server version of mssql server 2000 and these included
the latest MDAC components. Should I go ahead and install
MDAC 8? could this be an SP3 problem? should I install
SP3a?
>--Original Message--
>Check this article and see if it applies to you:
>http://support.microsoft.com/default.aspx?scid=kb;en-
>us;Q279526
>
>Edgardo Valdez
>MCSD, MCDBA, MCSE, MCP+I
>http://www.edgardovaldez.us/
>>--Original Message--
>>All of the servers are set to use Windows
authentication
>>only originally when I installed them and this is stil
so
>>when i just checked them. Could there be another reason
>>the main server is using the null account instead of
the
>>guest account to register with the satelite server? How
>>can I set this parameter?
>>
>>--Original Message--
>>Check if the server you are trying to connect to is
set
>>to
>>Windows Authentication Only and change the security
>>settings to SQL Server and Windows. It seems that you
>>are
>>using SQL authentication yourself and the other
machine
>>is
>>set to Windows Authentication only.
>>
>>Edgardo Valdez
>>MCSD, MCDBA, MCSE, MCP+I
>>http://www.edgardovaldez.us/
>>--Original Message--
>>Hi,
>>I am able to register other SQL server instances but
>>when
>>I try to register one in particular I am getting this
>>error on the main server to which I need to register
>>all
>>of the satelite servers. Can anyone help with this
>>problem? I don't understand why it is using a null
>>account instead of the guest account to try to log
into
>>this particular instance.
>>
>>Login failed for user '(null)'. Reason: Not
associated
>>with a Trusted SQl Server connection
>>.
>>.
>>.
>.
>

Registration edit for replication ?

I have a laptop on a LAN and I have pushed a new subscription to it. Now I
want to move the Laptop to its proper location (in another city for example)
and replicate to it via the internet.
Can I simply edit the server registration at the Publisher?
thank you,
bob
Bob,
assuming you don't intend to reinitialize, AFAIK there is no new
configuration necessarily required on the publisher. However, on the
subscriber there are various stipulations:
It'll need to be set up as a pull subscriber.
On the laptop you'll need to set up an alias in the client network utility
and place an entry in the hosts file to recognise the publisher.
For security, the pull agent will need to be set up to use SQL
authentication or passthrough windows authentication.
If you want to subsequently reinitialize, then changes will be necessary on
the publisher. You'll need to set @.enabled_for_internet = true so that FTP
can be used to download the snapshot.
HTH,
Paul Ibison
|||no. The subscriber in this case is probably set up for an push. Exactly how
is the publisher going to find the subscriber over the internet.
To get this to work you would have to update the lmhosts and/or the hosts
file for the new ip address, Client Network Utiltity for the new ip address.
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Robert A. DiFrancesco" <bob.difrancesco@.comcash.com> wrote in message
news:eSDh92DZEHA.2408@.tk2msftngp13.phx.gbl...
> I have a laptop on a LAN and I have pushed a new subscription to it. Now
I
> want to move the Laptop to its proper location (in another city for
example)
> and replicate to it via the internet.
> Can I simply edit the server registration at the Publisher?
>
> thank you,
> bob
>

Registration card returned by post office.

I recently purchased SQL Server 2000 Developer Edition
here in Canada. I mailed the registration card to the
P.O. Box in San Francisco as indicated on the
accompanying documentation.
The post office has returned the card with a stamp that
says "Box Closed: Forwarding Order Expired".
As I did not get asked to register on-line when I
installed the product, how do I register that I have
acquired this product ?Chris,
The best is to call the local MS subsidiary. Check the numbers at
www.microsoft.com/canada.
--
Dejan Sarka, SQL Server MVP
Please reply only to the newsgroups.
"Chris Smith" <chris.smith@.shaw.ca> wrote in message
news:088701c39fe5$f1774ac0$a001280a@.phx.gbl...
> I recently purchased SQL Server 2000 Developer Edition
> here in Canada. I mailed the registration card to the
> P.O. Box in San Francisco as indicated on the
> accompanying documentation.
> The post office has returned the card with a stamp that
> says "Box Closed: Forwarding Order Expired".
> As I did not get asked to register on-line when I
> installed the product, how do I register that I have
> acquired this product ?

Registration Benefit Portal - Page Nopt Found

Hi, this text is taken from the FAQ and contains the same link the Registration email I received, which don't work (for me!). The link points to http://go.microsoft.com/fwlink/?LinkId=52054. Does anyone else have this problem?

NOTE: You can directly access the Registration Benefit Portal without need of a first or second benefit e-mail—as long as you have completed the registration process and use the same e-mail to login in to Passport at the benefit porta

Hmm, working now!

registration and Replicatons

Is registration of the subscriber required to configure replications.
I am configuring replications over the internet using a VPN connection
and do not want the Publisher/Distributor (Publisher and Distributor
are the same) to have the Subscriber registered. I know you can add a
subscriber using the system stored procedure but I was wondering if
registration of the subscriber was a requirement to perform
replication.
Thank you in advance for your help.
It is required.
You must register the servers in your hosts file, client configuration utility, and EM. Then you must enable your subscriber using SQL Server authentication.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Gent" wrote:

> Is registration of the subscriber required to configure replications.
> I am configuring replications over the internet using a VPN connection
> and do not want the Publisher/Distributor (Publisher and Distributor
> are the same) to have the Subscriber registered. I know you can add a
> subscriber using the system stored procedure but I was wondering if
> registration of the subscriber was a requirement to perform
> replication.
> Thank you in advance for your help.
>

Registration access denied

Am I able to register SQL2005 server in Enterprise Manager of SQL2000, or SQL2000 server in SQL Server Management Studio?

You can use enterprise manager from sql 2005 to administer both sql 2000 and sql 2005 databases.

I doubt that the enterprise manager from sql 2000 would work with a sql 2005 database.

|||How should I use enterprise manager in SQL2005?|||

Its Management Studio.

From Management Studio, you can connect to both sql 2000 and sql 2005 databases.

http://www.aspfaq.com/sql2005/show.asp?id=3

|||this SQL Express, is there any stest I can use for SQL 2000?|||

Below is from previous link:

As for connecting to Express from application code, this should not be any different from connecting to a named instance of SQL Server 2000. Your connection string should look like this, assuming local machine and an instance name of SQLEXPRESS (you might need a different instance name, and you may have to use a machine name, rather than "." (which means local)).

Registration access denied

Am I able to register SQL2005 server in Enterprise Manager of SQL2000, or SQL2000 server in SQL Server Management Studio?

you can't use it even if it registers.

here's a story:

i have bothe Enterprise manager and management studio on the same box

what ever i register on the management studio gets registered to EM.

but the problem is i cant open version 9 Db on EM even it i see it on the list of server

Registration

I have a client that is running SQL 2005 Standard edition and they purchased 10 more Cal's, do I have to enter new registration keys, and if so where do you enter them?

Thanks in advance.

Joe

No, you don't have to enter additional reg keys.|||Thank you

Wednesday, March 7, 2012

Registration Problem

Upgrading and Uninstalling the Trial Software

Registration of SQL with WEB Server

Registration of SQL Servers missing in Enterprise manager

Registration of SQL Servers missing in Enterprise manager

Registration of SQL Server

Registration of SQL Server

Registration of mobile data provider for SQLCE

Registration of CLR-function sample fails

Registration from Enterprise Manager

Registration form problem. String or binary data would be truncated

Saturday, February 25, 2012

Registration failure in Enterprise Manager

Registration Fails

Registration error

Registration edit for replication ?

Registration card returned by post office.

Registration Benefit Portal - Page Nopt Found

registration and Replicatons

Registration access denied

Registration access denied

Registration

Registering Error

Blog Archive

About Me