Supersocket info spnregister error 1355

Supersocket info spnregister error 1355

This forum has migrated to Microsoft Q&A. Visit Microsoft Q&A to post new questions.

Answered by:

Question

I am running Ms SQL Server Standard Ed. with IIS 6.0 on a Windows 2003 Server.

Currently having some problems relating to access to database. IIS seem to work fine, as the welcome page which doesn’t require access to the SQL database can be opened without a problem. The page which authenticates the login, which contains a fileDSN info to access the SQL via ODBC gives me an error. It says :

Microsoft OLE DB Provider for ODBC Drivers error ‘80040e4d’

[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user ‘sa’.

But when i created the DSN file under ODBC, the test completed succesfully, using SQL Server authentication with user login and password.

On the other side, At the SQL Enterprise Manager, I check the authentication method, and it is set to Windows and SQL server (Mixed mode).

When i start my server, I receive this message in the event viewer,

SuperSocket info: (SpnRegister) : Error 1355

Does this has anything to do with the problem i m facing?

I tried reinstalling SQL Server, but i still receive this message. I even copied the database and the www pages to publish from my desktop, but no difference.

Источник

Supersocket info spnregister error 1355

This forum has migrated to Microsoft Q&A. Visit Microsoft Q&A to post new questions.

Answered by:

Question

I am running Ms SQL Server Standard Ed. with IIS 6.0 on a Windows 2003 Server.

Currently having some problems relating to access to database. IIS seem to work fine, as the welcome page which doesn’t require access to the SQL database can be opened without a problem. The page which authenticates the login, which contains a fileDSN info to access the SQL via ODBC gives me an error. It says :

Microsoft OLE DB Provider for ODBC Drivers error ‘80040e4d’

[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user ‘sa’.

But when i created the DSN file under ODBC, the test completed succesfully, using SQL Server authentication with user login and password.

On the other side, At the SQL Enterprise Manager, I check the authentication method, and it is set to Windows and SQL server (Mixed mode).

When i start my server, I receive this message in the event viewer,

SuperSocket info: (SpnRegister) : Error 1355

Does this has anything to do with the problem i m facing?

I tried reinstalling SQL Server, but i still receive this message. I even copied the database and the www pages to publish from my desktop, but no difference.

Источник

Supersocket info spnregister error 1355

This forum has migrated to Microsoft Q&A. Visit Microsoft Q&A to post new questions.

Answered by:

Question

I am running Ms SQL Server Standard Ed. with IIS 6.0 on a Windows 2003 Server.

Currently having some problems relating to access to database. IIS seem to work fine, as the welcome page which doesn’t require access to the SQL database can be opened without a problem. The page which authenticates the login, which contains a fileDSN info to access the SQL via ODBC gives me an error. It says :

Microsoft OLE DB Provider for ODBC Drivers error ‘80040e4d’

[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user ‘sa’.

But when i created the DSN file under ODBC, the test completed succesfully, using SQL Server authentication with user login and password.

On the other side, At the SQL Enterprise Manager, I check the authentication method, and it is set to Windows and SQL server (Mixed mode).

When i start my server, I receive this message in the event viewer,

SuperSocket info: (SpnRegister) : Error 1355

Does this has anything to do with the problem i m facing?

I tried reinstalling SQL Server, but i still receive this message. I even copied the database and the www pages to publish from my desktop, but no difference.

Источник

Supersocket info spnregister error 1355

Сообщения: 176
Благодарности: 3

«Пока что. » длилось не долго. Примерно месяц. Затем всё повторилось.
Проблемы были в ОЗУ и матери — их несовместимость. Затем сдох БП. А потом.

Короче, 1с переехала на:
— новую платформу,
— новый SQL,
— новый сервер.

Кардинальное решение.
Все были счастливы. Акромя директора.

Источник

SuperSocket Info: (SpnRegister) : Error 1355.

For hardware upgratdation we have to move our database server(MSSQL
2000) from a P3(Window 2003) machine to a p4(Windows 2003) machine. We
have replicated the data from P3 machine to P4 machine.

the replication was success full.

After this we have changed the name of the p4 machine to tha of p3
machine.

now when we try to connect to the new p4 machine using the windows
authentication we are not getting errror «Cannot generate SSPI
Context.»

for solving it we have tried to change the name of the sqlserver.
REF:
http://groups.google.co.in/group/mi. 0b0966be28f835e

while replication the database we have made the mssql service run under
a network account.
this could be a possible reason for not able to register with the ADS.
Later we have changed it to run under the local user account.

Any help will be highly appreciated.

Similar Messages:

SuperSocket Info: (SpnRegister) : Error 8344

i seem to be getting a lot of this «SuperSocket info: (SpnRegister) : Error 8344» errors in my event viewer. Does anyone know what this is ?

Error — SuperSocket Info: (SpnRegister): Error 8206

We just installed SQL Server 2000 (as part of SBS 2003) including service pack 3a.

When we reboot the server a message pops up that a service did not start properly.

The error is ‘SuperSocket info: (SpnRegister): Error 8206’.

I have searched here and other places on the Internet without any success.

All assistance is appreciated as we cannot continue.

SuperSocket Info: Bind Failed On TCP Port

Got a SQL Server 200 with two instances
1.SEAWEED
2.SEAWEEDUAT

After a recent reboot, both my instances weren’t able to be registered using Enterprise Manager or by clients.

Both MSSQL and SQL Server Agent on both instances run using a domain account user and were running.

Looking at some microsoft articles, i changed the Services on both instance
under a domain administrator account.

Now i am only able to register the default instance while the named instance keeps coming up with SuperSocket Info: Bind failed on TCP port 1078

Also created a DNS alias for the named instance but this did not resolve the issue.

Does anyone have any solutions/ideas of a quick fix/ workaround ?

SQL 2000 SP1 Supersocket Error

I stopped and started SQL Server this morning and got this error message in the NT EVent log and SQL log (SQL 2000 SP1)

Supersocket info: Bind Failed on TCP port 1433. This error is new, it was not there in previous starts of SQL Server 2000, Any ideas? thx in advance

How To Get More Info For Error Messages

So far I have not been able to figure out how to get more info
regarding the sql server errors. For example, I get this error
from sql server query analyzer (this just an example):

————
Server: Msg 128, Level 15, State 1, Line 5
The name ‘does’ is not permitted in this context.
Only constants, expressions, or variables allowed here.
Column names are not permitted.
————

Is there a way to find more information regarding this error, or
like Oracle has MeataLink, where you can search, if someone else
already got this error and how it got resolved?

Or how you folks go about resolving errors you get? Is it based
on trail and error, or experience (like already encountered this
type before) etc.?

Get Error Info On DTS Packages

I am executing a DTS package from within a java application using the xp_cmdshell procedure and dtsrun via JDBC.

My question is how do I pass back error info on the DTS package to my app?!

Any help is appreciated!

Info About Error 8623

SQL Server returned me error 8623 «Internal Query Processor Error: The query processor could not produce a query plan.» I’ve looked for info in the SQL books, but there’s no info about this error. I would appreciate it a lot if somebody could tell me what this error means, how is it triggered, and if it’s possible, how to avoid it.

Is There A System Table With Timestamp Info Or DTS Job Info?

I want to be able to see when records have been added to a table. The issue is we have a DTS job scheduled to run every night. The developer who wrote it password protected it and doesn’t work here anymore. I want to add a step to this series of DTS jobs and want to run it just prior to his job. Is there a way to see when the records are being added or when this job is being run? Thanks again, you guys are the best.

SQL Server 2000 And Transaction Log Error — More Info

Hi All:I am getting an error when trying to open a recordset in SQL Server 2000.The error states that the transaction log is full. Is there any way I canclear out or empty the transaction log, or get rid of it alltogether as itis not really needed?Any help would be appreciated.Thanks and regards,RyanThe error msg is: tempdb transaction log is full. B/U transaction log tofree up space. «

2 Questions: SQL Timeout Error, Can I Email Info From App To Me ?

Question 1: SQL TimeOut Error
I get this when i run my program and when it happens the program no longer displays data from the database. When i restart the program it seems to work fine. Is there away to fix this or at least make a message to the user telling them to restart the program?

Question 2: Can I e-mail form info to myself?
I want the user to be able to fill a form and click submit and have it emailed to myself. how can i go about doing that?

The Below is for a different project
Question 3: Picture Box’ and SQL
Can I make it so the user a browse for a picture as his Avatar or Just his Picture and the save it to the Database again?

ie
Fill In This Form To Complete Registration:
Picture: [Browse]
Name:
Date of Birth:
(at this point im going to stop)

Last Used DB Info

I’ve inherited the administration of two SQL Servers one 7.0 and the other 2000. We are looking into upgrading to 2005 so I’m gathering all the info I can on the DBs and applications using them.

Now, how can I check if a DB is currently in use? Is there a way to find out when a DB was last accessed?

By the way, I’ve never done DB administration so you can figure out how desperate I’m getting.

Thanks all for your help,

pratap writes » Dear respected sir,

i need small information regarding how the picture image data can be stored in the database and how it can be made possible. is there for the need for any conversion.

awaiting for your reply»

Between And More Info

Hi, I hope someone can help me with this.

I want to get a query from a database

from between ‘3’ AND ‘5’ (NO PROBLEM)

but I want to add that I want info from 7 and up

how would I write that ? (if I do it in seperate lines the query returns nothing) which is not true.

Help With Db Info.

Well i need to document what tables i have in my stored procedures. Im really new to sql as well. And the problem is if i try code i have or sp_depends for instance it will only tell me the tables that are in that DB so if I have multiple tables from different DB’s they are left out. I was told that sp_MSForEachDb for go through each DB and I could try it that way. Any help or example code dumbed down for me would be awesome. This was posted in a previous thread but i though this would be a better explanation

Need Info From 2 Tables

Here’s my string. I know it’s way wrong right now SELECT binbox_receipt.partner_code ,binbox_receipt.link_id ,binbox_receipt_archive.partner_code,binbox_receipt_archive.link_id FROM binbox_receipt, binbox_receipt_archivewhere binbox_receipt_archive.link_id = binbox_receipt.link_idand binbox_receipt.partner_code = ‘1154’ and binbox_receipt.link_id = ‘2684’and (binbox_receipt_archive.partner_code = ‘1154’ and binbox_receipt_archive.link_id = ‘2684’)I need to check 2 tables if in the first table the link_id and partner_code exist or the second table link_id and partner_code existany help would be greatly appreciated I’m a little new at this but having fun trying

Info Regarding MSDE

Iam not sure if the Question is approriate for this forum but here goes.

I have just started playing around with ASP .NET and since i do not have a lot of money i downloaded and installed MSDE as my database. So far i havent been able to find any free tools to access MSDE. Iam looking for GUI tools from where i can create Databases , tables etc. I have experience with MySQL database and am looking for something like MySQLAdmin for MSDE..

any help in this regard is appreciated

Need Help Parsing Out Info

I’m using a SQL selection to fill a DataGrid. One of the fields I have is called diagnosis. This field in the database can contain multiple diagnosis. But I use a set of characters to divide each diagnosis.
Example : Sick!@#$%Hurt!@#$%Ill!@#$%
My problem is this is how it looks in my Data Grid. Can someone tell me how to parse out each diagnosis.

Spid Info

Hi,
Here i have a question..
Whenever i see my spid in LOCK/PROCESS ID
one command DBCC BUFFERINPUT(MY SPID) always running
and it is showing »»tempdb.dbo.##lockinfo»’
MODE—- X
Is it pretty normal or something wrong..
i am not running any thing, just simply opened EM..
Pls any suggestions.
thank u

Triggers Info

Hello!
I’m new DBA.
I have triggers on my table in the database have been created one individual a long time ago. Sp_helptrigger stored procedure gave me just a little info about triggers. I would like to see the real code for each trigger, but I don’t have idea where to look for it.
Please help me to find it.

Processor Info

After Sql server has been installed. Is there a way to find out for the mode that it is installed in, ie per processor or per seat?

Info On SQLPERF

Can anyone point me in the direction of some online resource that explains, in detail, the statistics returned by DBCC SQLPERF?

Exception_Access_Violation Info

To all:
I have installed a new Compaq 7000 with NT4.0 sp3 and Sql Server 6.5 sp4 into production about two weeks ago.
Everything went fine until yesterday. Around noon I received 2 Exception_Access_Violation about a second apart
with two differend spids. About 20 mins later I got the Out of connections message and sql server stopped
reponding. I Could not stop sql server and had to reboot the server. I have configured the connections at 600
and generally we average a little over 400. Everything seems to be running fine now but I would like to get some
information from all the great minds out there!

What exectly is Exception_Access_Violation? Can I figure out what caused it or can I debug it? Do you think that the
EAV caused the out of connections error? Any help, insight would help greatly!

Thanks in advanced,
Glen Whitling

I Need Some Info On MS SQl Server 6.5

I am from India. My office has 15 location all over India. I am in corporate office.We have Ms Sql server 6.5. Also all other centers have
have same Ms Sql Server 6.5. We develop a Intranet based application.
In which Ms Sql Server 6.5 is the back end and Netscape browser is the front end.

The centers have their independent database. all also have different data structurre.
But the Head Office needs data from them. How the replication technology help us. and How we we will conect through internet or we haveto have seprate dedicated
leased lines back to centers.

What will be data structure .

Best Way To Log Statistical Info

I want to keep track of some application statistics.

-How many applications per day, month, year
-How many apps for a specific type of widget
-etc.

Is this best accomplished by a script that review the data or by using counters that are updated with every app?

Can someone give me some info on how to get started with this? I did a search, but only found a thread that recommends an article that costs $100.

Process Info

I want to check who access the database in the sql server. When i go to current activity then process info. I found not all the users who access the database are displayed. Even though i refresh it. It didn’t show up. But i am sure some user was accessing the database. Anybody know why, how can i avoid it. Thanks.

Sql Server Info

What is similar to «Schema» and «Table space» in SQL Server?

What is the physical organization/structure of SQL Server?

Thanks in advance,
Jai

Trace Info

Folks, I’ve inherited a SQL 2K server that has a trace running. I can see the trace file being generated(.trc), I can also see the standard templates(.tdf). But BOL is not helpful in finding information about the
trace when you have no information. I just want to shut the damn thing off.

I can open the trc file in SQL Profiler but I am not proficient in the tool’s use. I also don’t see a trace table anywere in the database.

If anyone can be of any help it would be much appreciated. Thanks.

Not Sure How To Get Info From Other Table

I am having problems with my store procedure displaying my last column name which is «DISPLAY_CATEGORY_DESC». I am trying to display the description from another table. But in order to get to the description I have to go through 2 tables. The tables look like something like this.

PRIMARY_KEY = DIR_CATEGORY_ID = 5000

Column Name
DIR_CATEGORY_LVL_ID1 = 100
DIR_CATEGORY_LVL_ID2 = 200
DIR_CATEGORY_LVL_ID3 = 300

Second TableTABLE_CATEGORY_DESCRIPTION
PRIMARY KEY DIR_CATEGORY_LVL_ID1 = 100

Column Name
DESCRIPTION = «Car Model Company»

This is my DISPLAY_CATEGORY_DESC

Not sure how to get to this description. Thanks for your help.

select cwebs.SESSION_ID, webs.ENTERED_DATE, cwebs.DIR_CATEGORY_ID, DISPLAY_CATEGORY_DESC

FROM di_webclickstats cwebs
left join di_websessions webs on cwebs.session_id = webs.session_id
where cwebs.DIR_CATEGORY_ID <> 0 and webs.ENTERED_DATE between @startDate and @endDate+1

Some Info On MS SQL Server

I have developed a great intrest in the MS SQL Server recently. I was just wondering if it was worth putting my time into learning this system. In the members opinion would SQL server be technically fit? Does it have a good campacity and flexibility? These areas are quite important to me. I would also like to know how web friendly the server is and its ability to handle complex data.

Any help would be much appriciated.

Newbie Need Some Info

I have been asked buy my boss to try and solve a problem. We have a access database which has a hell of a lot of entries. We want to use sql server to store this database now.

We want to be able to print reports and analyze the data by running queries etc.

Apart from the obvious sql server software, what would be required to acheive this, would i need a dedicated front end built?

Im just testing water at the moment looking for any info that i might need.

Exceptions Info

Vikas writes «can any one help me in getting the list of exceptions and there types and how to tackle them.»

Источник

Again, thank you for the reply Lian … that didn’t solve the problem, but there’s a new error along with the old one being Vlog:

10/20/2008 8:36:07 PM mid: 633601317679687500 code: 0 , Connectivity.Core.Exceptions.SysErrCodes.UnspecifiedSystemException System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

Server stack trace:
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteReader()
at Connectivity.Core.Database.SqlAccess.ExecuteReader(SqlConnection connection, SqlTransaction transaction, CommandType commandType, String commandText, SqlParameter[] commandParameters, SqlConnectionOwnership connectionOwnership, Int32 commandTimeout)
at Connectivity.Core.Database.SqlAccess.ExecuteReader(SqlConnection connection, SqlTransaction transaction, CommandType commandType, String commandText, SqlParameter[] commandParameters)
at Connectivity.Document.DataAccess.Files.CheckoutFile(Int64 folderId, Int64 fileMasterId, DateTime createDate, Int64 createUserId, String machineName, String localSpec, String comment, File& currFile)
at Connectivity.Document.Services.FileService.CheckoutFile(Int64 folderId, Int64 fileMasterId, String machine, String localpath, String comment, Boolean downloadFile, Stream& fileStream)
at System.Runtime.Remoting.Messaging.Message.Dispatch(Object target, Boolean fExecuteInContext)
at System.Runtime.Remoting.Messaging.StackBuilderSink.SyncProcessMessage(IMessage msg, Int32 methodPtr, Boolean fExecuteInContext)

Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
at Connectivity.Document.Services.FileService.CheckoutFile(Int64 folderId, Int64 fileMasterId, String machine, String localpath, String comment, Boolean downloadFile, Stream& fileStream)
at Connectivity.Web.Services.DocumentService.CheckoutFile(Int64 folderId, Int64 fileMasterId, String machine, String localPath, String comment, Boolean downloadFile)