Cannot login to SQL Server 2005 using SQL Server Authentication

I am unable to login to Server Management Express using Server
Authentication. I am able to login using Windows Authentication
though. I setup a new logic using Server Authentication but get the
following message:
Cannot connect to MIKE-PC.
===================================
A connection was successfully established with the server, but then an
error occurred during the login process. (provider: Shared Memory
Provider, error: 0 - No process is on the other end of the pipe.)
(.Net SqlClient Data Provider)
For help, click: [url]http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLS erver&EvtID=233&LinkId=20476[/url]
Server Name: MIKE-PC
Error Number: 233
Severity: 20
State: 0
I am running SQL Server 2005 Express on my local PC and would like to
use the SQL Server Authentication so that a VB programcan access the
database.
Any idea where to look for more info to resolve this?
Thanks in advance,
Mike Polinske
Milwaukee, WI
By default SQL Server is installed to only accept Windows (SSPI)
authentication credentials. You'll need to reconfigure (and restart) SQL
Server to handle mixed-mode security.
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant, Dad, Grandpa
Microsoft MVP
INETA Speaker
www.betav.com
www.betav.com/blog/billva
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
------
"Mike Polinske" <mikepolinske@.gmail.com> wrote in message
news:1187031553.693705.10860@.l22g2000prc.googlegro ups.com...
>I am unable to login to Server Management Express using Server
> Authentication. I am able to login using Windows Authentication
> though. I setup a new logic using Server Authentication but get the
> following message:
> Cannot connect to MIKE-PC.
> ===================================
> A connection was successfully established with the server, but then an
> error occurred during the login process. (provider: Shared Memory
> Provider, error: 0 - No process is on the other end of the pipe.)
> (.Net SqlClient Data Provider)
> --
> For help, click:
> [url]http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLS erver&EvtID=233&LinkId=20476[/url]
> --
> Server Name: MIKE-PC
> Error Number: 233
> Severity: 20
> State: 0
> I am running SQL Server 2005 Express on my local PC and would like to
> use the SQL Server Authentication so that a VB programcan access the
> database.
> Any idea where to look for more info to resolve this?
> Thanks in advance,
> Mike Polinske
> Milwaukee, WI
>
|||On Aug 13, 3:12 pm, "William Vaughn" <billvaNoS...@.betav.com> wrote:
> By default SQL Server is installed to only accept Windows (SSPI)
> authentication credentials. You'll need to reconfigure (and restart) SQL
> Server to handle mixed-mode security.
> --
> ____________________________________
> William (Bill) Vaughn
> Author, Mentor, Consultant, Dad, Grandpa
> Microsoft MVP
> INETA Speakerwww.betav.comwww.betav.com/blog/billva
> Please reply only to the newsgroup so that others can benefit.
> This posting is provided "AS IS" with no warranties, and confers no rights.
> __________________________________
> Visitwww.hitchhikerguides.netto get more information on my latest book:
> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
> and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
> ----X---
>
Thanks Bill, I was able to find the server properry under Security
that controls the authentication and it worked like a charm!!

Cannot login to SQL Server 2005 using SQL Server Authentication

I am unable to login to Server Management Express using Server
Authentication. I am able to login using Windows Authentication
though. I setup a new logic using Server Authentication but get the
following message:
Cannot connect to MIKE-PC.
===================================
A connection was successfully established with the server, but then an
error occurred during the login process. (provider: Shared Memory
Provider, error: 0 - No process is on the other end of the pipe.)
(.Net SqlClient Data Provider)
--
For help, click: http://go.microsoft.com/fwlink?Prod...33&LinkId=20476
--
Server Name: MIKE-PC
Error Number: 233
Severity: 20
State: 0
I am running SQL Server 2005 Express on my local PC and would like to
use the SQL Server Authentication so that a VB programcan access the
database.
Any idea where to look for more info to resolve this?
Thanks in advance,
Mike Polinske
Milwaukee, WIBy default SQL Server is installed to only accept Windows (SSPI)
authentication credentials. You'll need to reconfigure (and restart) SQL
Server to handle mixed-mode security.
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant, Dad, Grandpa
Microsoft MVP
INETA Speaker
www.betav.com
www.betav.com/blog/billva
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
----
---
"Mike Polinske" <mikepolinske@.gmail.com> wrote in message
news:1187031553.693705.10860@.l22g2000prc.googlegroups.com...
>I am unable to login to Server Management Express using Server
> Authentication. I am able to login using Windows Authentication
> though. I setup a new logic using Server Authentication but get the
> following message:
> Cannot connect to MIKE-PC.
> ===================================
> A connection was successfully established with the server, but then an
> error occurred during the login process. (provider: Shared Memory
> Provider, error: 0 - No process is on the other end of the pipe.)
> (.Net SqlClient Data Provider)
> --
> For help, click:
> http://go.microsoft.com/fwlink?Prod...33&LinkId=20476
> --
> Server Name: MIKE-PC
> Error Number: 233
> Severity: 20
> State: 0
> I am running SQL Server 2005 Express on my local PC and would like to
> use the SQL Server Authentication so that a VB programcan access the
> database.
> Any idea where to look for more info to resolve this?
> Thanks in advance,
> Mike Polinske
> Milwaukee, WI
>|||On Aug 13, 3:12 pm, "William Vaughn" <billvaNoS...@.betav.com> wrote:
> By default SQL Server is installed to only accept Windows (SSPI)
> authentication credentials. You'll need to reconfigure (and restart) SQL
> Server to handle mixed-mode security.
> --
> ____________________________________
> William (Bill) Vaughn
> Author, Mentor, Consultant, Dad, Grandpa
> Microsoft MVP
> INETA Speakerwww.betav.comwww.betav.com/blog/billva
> Please reply only to the newsgroup so that others can benefit.
> This posting is provided "AS IS" with no warranties, and confers no right=
s=2E
> __________________________________
> Visitwww.hitchhikerguides.netto get more information on my latest book:
> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
> and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
> ----=
--=AD---
>
Thanks Bill, I was able to find the server properry under Security
that controls the authentication and it worked like a charm!!

Cannot install Setup Support Files

Iâ'm unable to complete the first step of the install. For some reason the
Setup Support Files do not finish installing. When proceeding to the next
step I get a â'Microsoft SQL Server 2000 Reporting Services Setup was unable
to install on your computerâ'. â'Microsoft SQL Server 2000 Reporting Services
Setup encountered a problem and has rolled backâ'. I cannot get any further
than this. When I try the installer again it trys to install the Setup
Sopport Files again...
I am installing on Win2K Server SP4, recently rebuilt.
Below are the last few lines of the log file - it seems to be an issue with
finding the "InstalledInstances"? Any and all help much appreciated.
Cheers,
Nick
<EndFunc Name='UpdateComponents' Return='0' GetLastError='0'>
<Func Name='DwLaunchMsiExec'>
<Func Name='PerformDetections'>
0
Failed to find property in cache: InstalledInstances
Failed to perform discovery on machine: SYD123456
HRESULT: 2147749904
<EndFunc Name='PerformDetections' Return='2' GetLastError='183'>
<Func Name='FSetupLogging'>
<Func Name='CreateSetupLogCabs'>
Creating Setup Logs Cab "C:\Program Files\Microsoft SQL Server\80\RS Setup
Bootstrap\LOG\RSStp_.cab"Hi Nick,
I ran the same problem but only on one machine among 2 servers and 3
developers. Did you ever find answer (reason) for this and did you find a way
how to fix it? I did try to uninstall and reinstall SQL server but it doesn't
help.
Regards,
Nisad.
"NickB" wrote:
> Iâ'm unable to complete the first step of the install. For some reason the
> Setup Support Files do not finish installing. When proceeding to the next
> step I get a â'Microsoft SQL Server 2000 Reporting Services Setup was unable
> to install on your computerâ'. â'Microsoft SQL Server 2000 Reporting Services
> Setup encountered a problem and has rolled backâ'. I cannot get any further
> than this. When I try the installer again it trys to install the Setup
> Sopport Files again...
> I am installing on Win2K Server SP4, recently rebuilt.
> Below are the last few lines of the log file - it seems to be an issue with
> finding the "InstalledInstances"? Any and all help much appreciated.
> Cheers,
> Nick
> <EndFunc Name='UpdateComponents' Return='0' GetLastError='0'>
> <Func Name='DwLaunchMsiExec'>
> <Func Name='PerformDetections'>
> 0
> Failed to find property in cache: InstalledInstances
> Failed to perform discovery on machine: SYD123456
> HRESULT: 2147749904
> <EndFunc Name='PerformDetections' Return='2' GetLastError='183'>
> <Func Name='FSetupLogging'>
> <Func Name='CreateSetupLogCabs'>
> Creating Setup Logs Cab "C:\Program Files\Microsoft SQL Server\80\RS Setup
> Bootstrap\LOG\RSStp_.cab"
>|||Hi Nisad,
I did speak to MS support about it but between us we were unable to come up
with an answer within the timeframe my client required. Because we were
installing RS on a test box we decided to simply rebuild it in the hope that
would fix things. After that we had no problems doing the install.
Unfortunately we were none the wiser about what caused the issue.
Sorry...no real answer to the problem. Good luck.
Cheers,
Nick
"Nisad" wrote:
> Hi Nick,
> I ran the same problem but only on one machine among 2 servers and 3
> developers. Did you ever find answer (reason) for this and did you find a way
> how to fix it? I did try to uninstall and reinstall SQL server but it doesn't
> help.
> Regards,
> Nisad.
> "NickB" wrote:
> >
> > Iâ'm unable to complete the first step of the install. For some reason the
> > Setup Support Files do not finish installing. When proceeding to the next
> > step I get a â'Microsoft SQL Server 2000 Reporting Services Setup was unable
> > to install on your computerâ'. â'Microsoft SQL Server 2000 Reporting Services
> > Setup encountered a problem and has rolled backâ'. I cannot get any further
> > than this. When I try the installer again it trys to install the Setup
> > Sopport Files again...
> >
> > I am installing on Win2K Server SP4, recently rebuilt.
> >
> > Below are the last few lines of the log file - it seems to be an issue with
> > finding the "InstalledInstances"? Any and all help much appreciated.
> >
> > Cheers,
> > Nick
> >
> > <EndFunc Name='UpdateComponents' Return='0' GetLastError='0'>
> > <Func Name='DwLaunchMsiExec'>
> > <Func Name='PerformDetections'>
> > 0
> > Failed to find property in cache: InstalledInstances
> > Failed to perform discovery on machine: SYD123456
> > HRESULT: 2147749904
> > <EndFunc Name='PerformDetections' Return='2' GetLastError='183'>
> > <Func Name='FSetupLogging'>
> > <Func Name='CreateSetupLogCabs'>
> > Creating Setup Logs Cab "C:\Program Files\Microsoft SQL Server\80\RS Setup
> > Bootstrap\LOG\RSStp_.cab"
> >

Cannot insert row into table

Hello

Although I am able to delete a row from CatA table, I am unable to insert a row into the same table.

The rows are from 1 to 241, I accidentally deleted row 41, together with row 42 which I wanted to delete. But I can't reinsert row 41.

I see this message:

INSERT INTO [dbo].[CatA]([CatA_ID], [LName], [Auto], [Advertising], [Antiques], [Art], [Astrology])
VALUES(41, N'JSmith', '(null)', '(null)', '(null)', '(null)', '(null)')

Error: Query(1/2) Cannot insert explicit value for identity column in table 'CatA' when IDENTITY_INSERT is set to OFF.

Below are the settings for this table, I have tried to change the settings but I am prevented.

CatA_ID = Primary Key

Parameter and Value:

Identity = yes

Identity Seed = 1

Identity Increment = 1

IsRowGuidCol = No

What do I need to do, how do I reinsert the row 41 or insert a new row in the future?

Please advise.

Regards

Lynn

with an auto-incrementing field, you never use that field in your insert statement - it, by it's name, auto-increments whenever a row is added to the database table. You can't insert to a specific row, using the auto-increment table.

If you deleted item 41 and item 42 - the next item inserted will be item 43. You really don't need to worry that the auto-incrementing fields are not fully sequential - if they are missing some numbers, it doesn't matter at all.

remember, when inserting into the table, do not use the identity/auto-incrementing field in your insert statement.

|||

Hello augustwind

Thanks for the reply. When I was creating the tables, I just ticked the boxes. Is there a way I can undo this?

I don't mind if the numbers are not sequential, but I just can't insert a row.

If I try to insert using the next number in sequence or number 42 I get the error mentioned in my first post.

My database is SQL 2000 and I am editing with Aqua Data Studio.

I have the option to insert data directly into the table, but when I tried without inserting a number I saw this error.

INSERT INTO [dbo].[CatA]()
VALUES()

Error: Query(1/1) Line 2: Incorrect syntax near ')'.

How do I insert a row? If I need to use syntax, what is the correct syntax required?

Or how do I remove the auto insert in my table?

Thanks.

Regards

Lynn

|||

Hi

If you accidentally delete a record with an identity column you could follow those to restore it:

Set the Identity Specification(is Identity) of the identity column toNo -->insert the record you deleted -->Set the Identity Specification(is Identity) of the identity column toyes

Hope this helps.

|||

Hello

Thanks for your reply and help.

I now know that I am unable to insert data directly into the row.

Below is the syntex which I have found to work and which might assist other sql beginners.

SET IDENTITY_INSERT CatA OFF

INSERT INTO CatA ( [LName])
VALUES( N'SJones')

GO

Thanks

Lynn

|||Hi Lynn, the error message you mentioned in the first post should give you some prompt, you can temporarily turn onIDENTITY_INSERT when you want to insert a row with specifying identity number:

SET IDENTITY_INSERT?CatA ON

INSERT INTO [dbo].[CatA]([CatA_ID], [LName], [Auto], [Advertising], [Antiques], [Art], [Astrology])
VALUES(41, N'JSmith', '(null)', '(null)', '(null)', '(null)', '(null)')

SET IDENTITY_INSERT?CatA OFF

Cannot fine the object “MSmerge_ctsv_... Because it does not exists or you do not have permissio

I keep getting the following error message during the initial merge agent.

· “The merge process was unable to deliver the snapshot to the subscriber.If using Web synchronization, the merge process may have been unable to create or write the message file, when troubleshooting, restart the sychronzation with verbose history loggin and specify an output file to write.

· Cannot fine the object “MSmerge_ctsv_B5ECD41086F24A64B8040A41A75B2DC4”, Because it does not exists or you do not have permission.(source: MSSQLServer, Error number 15151)

I do see this view in the publication and if I run the following command on the publisher I get…

select * from Msmerge_ctsv_B5ECD41086F24A64B8040A41A75B2DC4

I get

tablenick rowguid generation partchangegen lineage colv1 marker logical_record_parent_rowguid logical_record_lineage

(0 row(s) affected)

I have another publication working on this same server that is working, both are from a copy from a template database.Please advise to what this problem could be and what I can do to resolve this.

Thank you,

Pauly C

The issue was the mobile server name was changed but not dropped and re-added back so the values of@.@.servername and serverproperty(‘servername’) did not match. Once I fixed this everything replicated fine. Not a very intuitive error but if the error returns somethign like "Cannot fine the object “MSmerge_ctsv_..." check the subscriber server name by running

select @.@.servername as oldservername, serverproperty('servername') as newservername, case when @.@.servername <> serverproperty('servername') then '*** Error - Server name changed, replication will not work' else 'Replication friendly' end as cMessage

also this is a script I use to run the procs to drop and add the server...

Use Master

IF (select SERVERPROPERTY('ServerName')) <> (SELECT @.@.Servername )

begin

DECLARE @.SQL VARCHAR(256), @.oldsvrname varchar(128), @.newsvrname varchar(128)

select @.oldsvrname = cast(@.@.servername as varchar(128)), @.newsvrname = cast(SERVERPROPERTY('ServerName') as varchar(128))

set @.SQL = 'Sp_DropServer @.server = ''' + @.oldsvrname + ''', @.droplogins =''droplogins'''

exec( @.SQL)

SET @.SQL = 'Sp_Addserver @.server =''' + @.newsvrname + ''', @.local= ''LOCAL'' , @.duplicate_ok = ''duplicate_OK'' '

exec(@.SQL )

end

** must restart services at this point.

Thank you,

Pauly C

|||Maybe if you would run the agent with a higher OutputVerboseLevel, perhaps it may have given you clues.|||Actually I did that but it gave the same error message.