Cannot push subscription - See image attached

I cannot seem to get my subscription to push. It's status is being
shown as "Never Started". How do I get this back in operation?
http://www.chuckchamblee.com/tcifiles/Image1.jpg
Can you check the owner of the job. If it is a domain user, please change to
sa and then see if you can manually start the job.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Cannot open database "database" requested by the login

We have a back end procedure that inserts/updates records in a table. Usually the upload file will have around 20k records. This procedure is called from our application which is designed using hibernate,struts.

Upload is getting completed. But after the upload is over and control goes to application code, we are again hitting the above table to get some details. Is this the root cause for the below issue?

This is what we get in application logs,

SQL Error: 4060, SQLState: S1000
2007-04-30 16:17:27,840 - ERROR [TP-Processor2] JDBCExceptionReporter.logExceptions(58) | Cannot open database "sdgebis" requested by the login. The login failed.
2007-04-30 16:17:27,840 - WARN [TP-Processor2] JDBCExceptionReporter.logExceptions(57) | SQL Error: 18456, SQLState: 28000
2007-04-30 16:17:27,840 - ERROR [TP-Processor2] JDBCExceptionReporter.logExceptions(58) | Login failed for user 'sa'.

2007-04-30 16:17:27,856 - WARN [TP-Processor2] SQLErrorCodeSQLExceptionTranslator.translate(279) | Unable to translate SQLException with errorCode '4060', will now try the fallback translator

What could be the reason for the above error?

Can anyone help me out please?Sounds like the two connections use different logins. And only one of them is mapped to a user in the database.

Cannot Open .bak File from ms sql database. either 2000 or 2007

Can not open mssql .bak file in ms_sql. File starts with "ti" and some
weired charctor. Can some one help me on how to open this back up of
mssql database. I've tried to restore this file in mssql and it says it
does not recognize this file. I understand that .bak file for mssql
should start with "tape". But when i opened this file in ms excel it
show the file starting with "ti" not tape.

Any help on this would be appreciated and please let me know if you
need access to file.

Thanks(Rizwan.Bakhshi@.gmail.com) writes:

Quote:

Originally Posted by

Can not open mssql .bak file in ms_sql. File starts with "ti" and some
weired charctor. Can some one help me on how to open this back up of
mssql database. I've tried to restore this file in mssql and it says it
does not recognize this file. I understand that .bak file for mssql
should start with "tape". But when i opened this file in ms excel it
show the file starting with "ti" not tape.
>
Any help on this would be appreciated and please let me know if you
need access to file.

I will have to admit that I did not know about the TAPE thing, but I
looked at some backups, and indeed they had TAPE in the beginning.
Except one from SQL 6.5, which had MSSQL.

Anyway, with the information that .bak file could be anything. Or do
you have a special reason that it is an SQL Server backup file?

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

Cannot Modify tables after Replication Switched off

If you run:
select replinfo from sysobjects
where name = 'yourtablename'
What comes back? If there is a 1, then update it to 0. If
it's not a 1 then I'll have a rethink!
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
"Adrian320" wrote:

> What if the number in sysobjects is 3 instead of 1, no problem?
> If I get the error message that ad hoc updates to sysobjects is not
> configured, how do I change that parameter.
> Thanks.
In Enterprise manager: Check "Allow modifications to be made directly to the
system catalogs" under Tools ->SQL Server Configuration Properties ->Server
Settings.
|||What if the number in sysobjects is 3 instead of 1, no problem?
If I get the error message that ad hoc updates to sysobjects is not
configured, how do I change that parameter.
Thanks.
"Paul Ibison" wrote:

> If you run:
> select replinfo from sysobjects
> where name = 'yourtablename'
> What comes back? If there is a 1, then update it to 0. If
> it's not a 1 then I'll have a rethink!
> Rgds,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>

CANNOT INSERT A NULL VALUE INTO TABLE RECORD

Hi all!

I'm runing an access application that has an sql server 2000 as its back end. Up to few weeks ago everything was fine, but now when a user tries to add a record from an access form into the database I get an error that it cannot insert a null value into the field.

The two fields that cause the problem do not allow nulls as they keep the user name and the time that the record was inserted into the table.

I trace the access program but I cannot pinpoint where the valuees are inserted into the table. All the other fields are bound on the form. When the problem first appeard I found out that at that same day the active directory server that keeps the logins to the network was restarded. The problem appears on the live database that the users use and as well as on my test sql server that is not connected to the main database server but is instaled on my pc together with the access application.

But I still have to login onto the same network to use my pc that is part of the same domain

The authentication on the sql server 2000 is windows only.

Any solutions or directions for this proplems?

Thanks for any help

George

Hi,

One initial step you could try would be to use SqlProfiler to see what you are insterting into the table so that you can see if the fields are misaligned by your program or not. Based on your input, I would also make some explicit checks in the program to ensure that your username is being appropriately set so that you can find out if the active directory server is correctly configured.

I hope this helps,

John (MSFT)

|||

Thanks for the promt reply!

Using the sql profiler gives me no clue.

This is the insert query from the profiler.

exec sp_executesql N'INSERT INTO "ENVIS_GSD".."wat_springflow" ("result_dt","site_id","result_va","remark_tx") VALUES (@.P1,@.P2,@.P3,@.P4,@.P5,@.P6)', N'@.P1 datetime,@.P2 int,@.P3 float,@.P4 nvarchar(4),@.P5 varchar(3),@.P6 datetime', 'Feb 10 2009 12:00:00:000AM', 3000723, 8.000000000000000e-001, N'test'

The two records that I get the proplem on are not included here, but somehow they have been updated. I traced the access code, but I could see no reference to them that they were used for the update in either the form or any modules called.

Somehow up to a few weeks ago those two columns were updated.

Tracing the code and using the immediate window the user_name variable stores the login name corectly.

Someone mentioned "error 28" any ideas?

Thanks in advance

George