Error restoring database

When attempting to restore a database, I get the following error:

'Cannot open backup device, (filename).bak, Operating system error 5, access is denied.'

I get similar errors when attempting to attach the database file, it shows up in the Mngt. Tool as 'read only'.

This error does not occur when restoring the same .bak file to other pc's. On the problem pc, we have completely uninstalled and reinstalled Sql Express and Mngt. Tool Express. It occurs whether logged in as full administrator or other user.

check the path where the backup file resides whether you could access it....may be that mite cause the above error|||Which OS are you running on ? using Vista it might be caused that you don′t have elevated rights (although logged on with an administrator account)

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||

OS is xp-pro.

The directory of the file is accessible as well.

|||

Are you connecting using SQL Server authentication ? Then you will be impersonated with the SQL Server account which is running the service on the machine. If this one does not have permissions on the file / directory, then you probably will get the Permission denied error message.

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||

Have tried using SQL authentication and windows authentication. How do you determine if the sql server account has particular permissions on the file/directory?

|||

just right click the file/directory and go to security tab and check the permission for the sql service account

Error open/accessing a MSSQL Linked Server

Hi!

Im having the fallowing error when I try to open/access a linked server
Error:
Error 7302: Could not create an instance of OLE DB provider 'MSOLAP.2'.
OLE DB error trace [Non-interface error: CoCreate of DSO for MSOLAP.2 returned 0x80004005].

I have already tried to create the server using SEM and also with SQL syntax in ISQLW.
Code:
EXEC sp_addlinkedserver
@.server='LINKED_OLAP',
@.srvproduct='',
@.provider='MSOLAP.2',
@.datasrc='MyServerName.MyDomain,
@.catalog='MyDataBase'

Im allowed to create the linked server but I cant use it.

Information:
OS: Windows 2003EE
SQL: MSSQL 2000 + SP3a
MDAC: MDAC2.8 rtm

Thanks,
Paulowhen referring to objects defined in a linked server, you should use the convention:
servername.databasename.userid.object|||That it's not the problem for sure.|||I'd see if any of Microsoft's (http://search.microsoft.com/search/results.aspx?view=msdn&st=b&na=82&qu=0x80004005+OLAP&s=1) ideas help.

-PatP|||Thanks, but none of the links apply to.

Paulo

Error on updating/adding record

I upsized (using Upsize Wizard) ACCESS back end to MSSQL 2000. Front end is still ACCESS. I'm getting error when trying to add or updated a record entry from front end.
The error message reads: 'Error # 3027 was generated by DAO.Recordset Cannot update. Database or object is read only.'

Thanks for any help.you should be using ADO not DAO

Error on query execution in VBA Excel using ADODB on SQL Server

We're trying to upsize from MS Jet (Access) db to SQL Server and am having a
major problem. Because we've not seen this error with the MS Jet db, I
suspect it's related to the user configuration in SQL Server.
The servername is "sqlbox" and the database name is "TCR". We use WinNT
authentication on the db and have a user profile for all our domain users.
The connection string executes, but the query does not. If the VBA Project
is unlocked, an error stating "Application Error...Unspecified Error" occurs
at the line noted below (--> ). When the VBA Project is locked (normally),
the error states "Invalid object name" and then lists the database table (in
this example, "Version").
Here's the pertinent code:
strConn = "Provider=SQLOLEDB;Data Source=sqlbox;" & _
"Persist Security Info=False;Initial Catalog=TCR;" & _
"Integrated Security=SSPI"
Set adoConn = New ADODB.Connection
adoConn.ConnectionString = strConn
adoConn.Open
strSQL = "SELECT * from Version WHERE Version.Filename = '" & strFname & "';
"
' open a recordset from Version table
Set adoRec = New ADODB.Recordset
adoRec.CursorLocation = adUseClient
--> adoRec.Open strSQL, adoConn <-- Error occurs here
I can run the application without problems; perhaps it is because I am the
dbowner (which implicitly grants me full access to the tables). However, I
have granted full access to the Domain User profile without success by any
other user.
Unless I find a way to solve this, there will be no migration! Thanks in
advance!Hi Glenn
You posted in the wrong place. There is a dedicated new group forACCESS/SQL
SERVER/ADP Integration. You will get better answers there as they are
specialized in that.
Regards
R.D
"Glenn Ray" wrote:

> We're trying to upsize from MS Jet (Access) db to SQL Server and am having
a
> major problem. Because we've not seen this error with the MS Jet db, I
> suspect it's related to the user configuration in SQL Server.
> The servername is "sqlbox" and the database name is "TCR". We use WinNT
> authentication on the db and have a user profile for all our domain users.
> The connection string executes, but the query does not. If the VBA Projec
t
> is unlocked, an error stating "Application Error...Unspecified Error" occu
rs
> at the line noted below (--> ). When the VBA Project is locked (normally)
,
> the error states "Invalid object name" and then lists the database table (
in
> this example, "Version").
> Here's the pertinent code:
> strConn = "Provider=SQLOLEDB;Data Source=sqlbox;" & _
> "Persist Security Info=False;Initial Catalog=TCR;" & _
> "Integrated Security=SSPI"
> Set adoConn = New ADODB.Connection
> adoConn.ConnectionString = strConn
> adoConn.Open
> strSQL = "SELECT * from Version WHERE Version.Filename = '" & strFname & "
';"
> ' open a recordset from Version table
> Set adoRec = New ADODB.Recordset
> adoRec.CursorLocation = adUseClient
> --> adoRec.Open strSQL, adoConn <-- Error occurs here
> I can run the application without problems; perhaps it is because I am the
> dbowner (which implicitly grants me full access to the tables). However,
I
> have granted full access to the Domain User profile without success by any
> other user.
> Unless I find a way to solve this, there will be no migration! Thanks in
> advance!

Error messages upsizing from MSAccess database to SQLServer

I am trying to use SQLServer for the first time and I am trying to use the upsizing wizard on Access to get moved over to SQLServer. I am getting the following error messages:

Connection failed:

SQLState: '01000'

SQL Server Error: 2

[Microsoft][ODBC SQL Server][Shared Memory]ConnectionOpen (Connect()).

Connection failed:

SQLState: '08001'

SQLServer Error: 17

[Microsoft][ODBC SQL Server][Shared Memory]SQL Server does not exist or access denied.

Does anyone know how I should proceed? Any help would be appreciated.

Thanks

Which version of SQL Server are you using?

Does the following help

http://blogs.msdn.com/sqlexpress/archive/2004/07/23/192044.aspx

|||I am using SQL Server 2005 Express|||Did you try the steps in the link I provided?|||

I did all the steps and I got the following error message:

ODBC - call failed.

I also tried this: I wrote a new database that had only one table in it (no forms or queries) and a few records in that table. That test database did get upsized just fine. But when trying to upsize the database I really need, I still got the "ODBC - call failed" error message.

Do you have any recommendations.

Thanks

Mark

|||

http://support.microsoft.com/?scid=kb;en-us;303257&spid=2509&sid=49

HTH

Error messages upsizing from MSAccess database to SQLServer

I am trying to use SQLServer for the first time and I am trying to use the upsizing wizard on Access to get moved over to SQLServer. I am getting the following error messages:

Connection failed:

SQLState: '01000'

SQL Server Error: 2

[Microsoft][ODBC SQL Server][Shared Memory]ConnectionOpen (Connect()).

Connection failed:

SQLState: '08001'

SQLServer Error: 17

[Microsoft][ODBC SQL Server][Shared Memory]SQL Server does not exist or access denied.

Does anyone know how I should proceed? Any help would be appreciated.

Thanks

Which version of SQL Server are you using?

Does the following help

http://blogs.msdn.com/sqlexpress/archive/2004/07/23/192044.aspx

|||I am using SQL Server 2005 Express|||Did you try the steps in the link I provided?|||

I did all the steps and I got the following error message:

ODBC - call failed.

I also tried this: I wrote a new database that had only one table in it (no forms or queries) and a few records in that table. That test database did get upsized just fine. But when trying to upsize the database I really need, I still got the "ODBC - call failed" error message.

Do you have any recommendations.

Thanks

Mark

|||

http://support.microsoft.com/?scid=kb;en-us;303257&spid=2509&sid=49

HTH

Error messages in Client

Hi
I am running a software package that access SQL Server files. I am getting
these messages:
* "Invalid pointer operation"
* "The RPC server is unavailable"
* "Access violation at address 40006834 in module 'rtl60.bpl'. Read of
address FFFFFFFF" when deleting an event
* "Access violation at address 40006834 in module 'rtl60.bpl'.
Anyone know what may cause these
Thanks
c
I would ask the vendor of the software package as these sound like
application errors, not SQL Server errors.
Andrew J. Kelly SQL MVP
"cds" <cdsaus2001@.yahoo.com.au> wrote in message
news:42be882f$0$14822$afc38c87@.news.optusnet.com.a u...
> Hi
> I am running a software package that access SQL Server files. I am getting
> these messages:
> * "Invalid pointer operation"
> * "The RPC server is unavailable"
> * "Access violation at address 40006834 in module 'rtl60.bpl'. Read of
> address FFFFFFFF" when deleting an event
> * "Access violation at address 40006834 in module 'rtl60.bpl'.
>
> Anyone know what may cause these
>
> Thanks
> c
>

Error message when deploying cube to remote server

Hello,

I created an account called sa2 to obtain access to create a datasource for the AdventureworksDW sample database on a remote server, and granted this user all rights on the database.

When I was ready to deploy the cube I typed in the machine name (sserver) in connection settings, and then deployed. However, I got an error:

"The connection either timed out or was lost."

I then tried:

sserver\sserver

but got:

"Error 1 The project could not be deployed to the 'sserver\sserver' server because of the following connectivity problems : A connection cannot be made to redirector. Ensure that 'SQL Browser' service is running. To verify or update the name of the target server, right-click on the project in Solution Explorer, select Project Properties, click on the Deployment tab, and then enter the name of the server. 0 0

Permissions issue for the sa2 account?

Are you trying to deploy from BIDS? Is the error message coming up during deployment or during processing?|||

Hello,

Yes, from Bids. Not sure at what point the error occurs, I select deploy, processing occurs and then the error message is displayed.

Since this post I dropped the firewall on the server, and the database seems to be ceated but errors occur, so deployment is not successful.

This link:

http://www.sqljunkies.com/WebLog/edwardm/archive/2006/05/26/21447.aspx

is suggesting that I can only login with a Windows account.

|||You need a Windows Account with administrator access to the Analysis Server to deploy the database (not necessarily an Windows Administrator account). You can use a SQL Server login for the connection from Analysis Services to the relational engine.|||Make sure you used the same windows login with remote server, same username and same password. I think the problem was in authentication method.

Best regards,

Hery|||

Hello,

Thanks for the suggestions everyone. The computer from which I am trying to deploy does not login to the network, so I don't have a profile which I can apply to the database. As a workaround for now I will deploy to localhost.

Error Message when accessing Report Manager

Whenever I try to access Report Manager, I get this message. I don't know what caused it. I recently installed Crystal Reports v11 & Oracle 10gEX evaluation apps. Could they have caused this? How do I fix this?

Product:SQL Server Reporting ServicesEvent ID:rsReportServerDisabledSource:Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.StringsVersion:8.00Message:Unable to encrypt or decrypt data managed by the Report Server instance. Please refer to the Reporting Services online help for guidance in enabling this functionality.

Explanation

A symmetric key is a single key used to encrypt and decrypt data. Reporting Services encrypts the symmetric key itself, using the public key of a specific user account on a specific computer. This error occurs when the public key that the user account provides does not match the public key that report server is expecting. Conditions that cause this error to occur include changing the name of a report server instance, moving the report server instance to a different computer, or changing the account under which the Report Server service runs.

User Action

A system administrator on the computer running the report server service can use a backup copy of the public key to get the report server running again. Use the rskeymgmt utility to apply the backup key set. If you do not have backup of the key, you must run the rskeymgmt utility to delete all of the encrypted content, run the rsconfig utility to respecify the encrypted connection values used to connect to the report server database, restart the service, and retype stored credentials for all reports that use stored credentials. For more information this utility, search Books Online.

---

The encryption keys are tied to the service account user. If any of those programs reset the ASP.Net account, it would cause this error.

Have you tried following the steps listed under "User Action"? Depending on which accounts were reset, you might be able to use rsactivate -r if you do not have a backup key.|||Brian:

Pardon my lack of knowledge but exactly how does one access the "rsactivate -r". Do I type this into the "run" text block?

I have found the rskeymgmnt.exe & rsconfig.exe files. Rvery time I click the executable the command window pops open & immediately closes.

I apologize for asking such elementary questions but it is difficult to get answers outside of the expert forums.

Thanks, Jack|||Brian:

Can you tell me how to retrieve a backup key? I default installed SQL Server 2000 and later Reporting Services. I do not recall setting up a backup key. Can I use rekeymgmt -e to extract a key to a text file? Can I use rekeymgmt -a to apply it before I try to get into Report Manager?

When you say "any of those programs reset the ASP.Net account", I assume you are referring to either Oracle Express or Crystal Reports?

Do I type rsactivate -r into the "run" text box? Do I type any other characters with it? Do i need to type a specific account name with the reset commandor will a generic "rsactivate -r" reset all.

I am obviously a beginner. I would appreciate the help.|||Rsactivate and rskeymgmt are command line tools. You will want to open a command window and run the programs from there. You can run rsactivate /? and rskeymgmt /? to get more help on other flags you will need. Also see the MSDN documentation at http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsuiref/htm/cpu_rsconfig_v1_6yqq.asp and http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsuiref/htm/cpu_rsconfig_v1_29ly.asp for example usage and a description of what the various flags do.

Error Message through access

HI I have access on the front end and SQL server as the engine, and I have a stored procdure in a macro called update. Now the problem with macro is when I execute it on to someone else computer I get an error message but when I execute it on my computer no error message and no macro Halt?? Anyone know what the deal is??I'd suggest that you check to see what the error message says. That could help a lot.

-PatP|||heres the message I am getting|||I'm 99% sure that the problem is object ownership. My guess would be that if you run:EXECUTE sp_help InsertTerms that the "owner" in the first line will not be dbo. To make it dbo so that the object can be seen by all users, you would use:EXECUTE sp_changeobjectowner 'InsertTerms', 'dbo'-PatP|||Open stored procedure...when did they add that?

And where do the result sets go?

What if a sproc returns more than 1.

I'll have to monkey around with this....|||All my problems today are solved I am so happy woohoooo...Pat and Bret I adore you...THANK YOU AGAIN

and more important I learned something, I do mean I learned something ahhh its all starting to come together like pieces to a puzzle

:):):):)

Error message in wrong language?

I want to give users access to full-text searching and presume that I can
let SQL-server do all the dirty work. If I pass in a syntax error, things
fail as expected and I get an appropriate error message in the exception.
If I pass in a query with only "a" (for example) with only ignored words,
the exception is thrown with an error message in Spanish!
"Una proposizione della query conteneva solo parole ignorate."
Since syntax errors on the same stored procedure come back in English, I
assume my culture is correct (and I set it explicitly). If call the stored
procedure from DevStudio with the same params, the error message is in
English.
Any ideas?
thanks
charles
DETAILS:
The stored procedure:
ALTER PROCEDURE dbo.GetMessageList
(
@.ForumID int,
@.FullTextSearch nvarchar(200)='',
@.BeginDate DateTime=NULL,
@.EndDate DateTime=NULL,
@.IsModerator bit=0
)
AS
SELECT
ForumMessages.ID,Title,MessageBody,Format,Locked,I mportance,Hidden,PostTime,
UpdateTime,EventDate,Alias,Views,
(SELECT COUNT(ID) FROM ForumMessages AS F1 WHERE
ForumMessages.ID=F1.RootParentID) AS Replies
FROM ForumMessages, ForumUsers
WHERE
ParentID IS NULL AND
ForumID=@.ForumID AND
(@.IsModerator=0 OR Hidden=0) AND
(@.BeginDate IS NULL OR EventDate>=@.BeginDate) AND
(@.EndDate IS NULL OR EventDate<=@.EndDate) AND
ForumUsers.ID=UserID AND
(@.FullTextSearch='' OR ForumMessages.ID IN
(SELECT RootParentID FROM ForumMessages WHERE
CONTAINS(Title,@.FullTextSearch) OR CONTAINS(MessageBody,@.FullTextSearch)
)
OR ForumMessages.ID IN
(SELECT ID FROM ForumMessages WHERE CONTAINS(Title,@.FullTextSearch) OR
CONTAINS(MessageBody,@.FullTextSearch)
)
)
ORDER BY Importance DESC,UpdateTime DESC
RETURN
are you getting this message in Query Analyzer? If so which language is it
being returned in?
Are you getting it in ADO? If so, what is your localeID, and what are your
regional settings (check control panel for this).
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"charles" <spam@.synthigence.com> wrote in message
news:O$WT0wvhEHA.3200@.TK2MSFTNGP10.phx.gbl...
> I want to give users access to full-text searching and presume that I can
> let SQL-server do all the dirty work. If I pass in a syntax error, things
> fail as expected and I get an appropriate error message in the exception.
> If I pass in a query with only "a" (for example) with only ignored words,
> the exception is thrown with an error message in Spanish!
> "Una proposizione della query conteneva solo parole ignorate."
> Since syntax errors on the same stored procedure come back in English, I
> assume my culture is correct (and I set it explicitly). If call the
stored
> procedure from DevStudio with the same params, the error message is in
> English.
> Any ideas?
> thanks
> charles
> DETAILS:
> The stored procedure:
> ALTER PROCEDURE dbo.GetMessageList
> (
> @.ForumID int,
> @.FullTextSearch nvarchar(200)='',
> @.BeginDate DateTime=NULL,
> @.EndDate DateTime=NULL,
> @.IsModerator bit=0
> )
> AS
> SELECT
>
ForumMessages.ID,Title,MessageBody,Format,Locked,I mportance,Hidden,PostTime,
> UpdateTime,EventDate,Alias,Views,
> (SELECT COUNT(ID) FROM ForumMessages AS F1 WHERE
> ForumMessages.ID=F1.RootParentID) AS Replies
> FROM ForumMessages, ForumUsers
> WHERE
> ParentID IS NULL AND
> ForumID=@.ForumID AND
> (@.IsModerator=0 OR Hidden=0) AND
> (@.BeginDate IS NULL OR EventDate>=@.BeginDate) AND
> (@.EndDate IS NULL OR EventDate<=@.EndDate) AND
> ForumUsers.ID=UserID AND
> (@.FullTextSearch='' OR ForumMessages.ID IN
> (SELECT RootParentID FROM ForumMessages WHERE
> CONTAINS(Title,@.FullTextSearch) OR CONTAINS(MessageBody,@.FullTextSearch)
> )
> OR ForumMessages.ID IN
> (SELECT ID FROM ForumMessages WHERE CONTAINS(Title,@.FullTextSearch) OR
> CONTAINS(MessageBody,@.FullTextSearch)
> )
> )
> ORDER BY Importance DESC,UpdateTime DESC
> RETURN
>
|||With Query analyser the error comes back in English. Don't know about ADO,
my app is in C# and uses the SqlClient calls. But I've only found this one
message in Spanish. Does the Full-text system have a separate language
configuration entry? Also, my App is multilingual, when a user selects a
different language, how will I tell SQL-Server what language should be used
for error messages?
thanks
charles
"Hilary Cotter" <hilaryk@.att.net> wrote in message
news:eImiwiyhEHA.712@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> are you getting this message in Query Analyzer? If so which language is it
> being returned in?
> Are you getting it in ADO? If so, what is your localeID, and what are your
> regional settings (check control panel for this).
> --
> Hilary Cotter
> Looking for a book on SQL Server replication?
> http://www.nwsu.com/0974973602.html
>
> "charles" <spam@.synthigence.com> wrote in message
> news:O$WT0wvhEHA.3200@.TK2MSFTNGP10.phx.gbl...
can[vbcol=seagreen]
things[vbcol=seagreen]
exception.[vbcol=seagreen]
words,
> stored
>
ForumMessages.ID,Title,MessageBody,Format,Locked,I mportance,Hidden,PostTime,
>
|||I added an explicit SET LANGUAGE to my sp and the problem is corrected.
charles
"charles" <spam@.synthigence.com> wrote in message
news:uMSxblSiEHA.3548@.TK2MSFTNGP09.phx.gbl...
> With Query analyser the error comes back in English. Don't know about
ADO,
> my app is in C# and uses the SqlClient calls. But I've only found this
one
> message in Spanish. Does the Full-text system have a separate language
> configuration entry? Also, my App is multilingual, when a user selects a
> different language, how will I tell SQL-Server what language should be
used[vbcol=seagreen]
> for error messages?
> thanks
> charles
>
> "Hilary Cotter" <hilaryk@.att.net> wrote in message
> news:eImiwiyhEHA.712@.TK2MSFTNGP09.phx.gbl...
it[vbcol=seagreen]
your[vbcol=seagreen]
> can
> things
> exception.
> words,
I
>
ForumMessages.ID,Title,MessageBody,Format,Locked,I mportance,Hidden,PostTime,[vbcol=seagreen]
CONTAINS(MessageBody,@.FullTextSearch)
>

Error message from server: The log file is full. Backup transactio

Hi,
I am working on a Access Sql system where I need to put a new release for a
system. This system involves transactional replication. Most of new screens
and code relate to client side sql server and the main server. When I am
trying to test some functionality on the server (main) side I am getting the
above error. Right now the main database file is 1. GB while the transaction
file is 76 GB. The problem is I cannot backup this database on the server as
it tells the log file is full. So I am not sure how to handle this situation
without having the ability to have a backup. Any help is appreciated. ThanksOn Mar 25, 10:12 am, Jack <J...@.discussions.microsoft.com> wrote:
> Hi,
> I am working on a Access Sql system where I need to put a new release for a
> system. This system involves transactional replication. Most of new screens
> and code relate to client side sql server and the main server. When I am
> trying to test some functionality on the server (main) side I am getting the
> above error. Right now the main database file is 1. GB while the transaction
> file is 76 GB. The problem is I cannot backup this database on the server as
> it tells the log file is full. So I am not sure how to handle this situation
> without having the ability to have a backup. Any help is appreciated. Thanks
try using DBCC SHRINKFILE to shrink the log file in conjunction with
the BACKUP LOG command, use sp_helpfile to find the log files logical
name, something like the following
SP_HELPFILE
this will return the logical name of the log file
DBCC SHRINKFILE (<LogicalName>)
I believe this moves all the data to the start of the file
BACKUP LOG <dbname> WITH TRUNCATE_ONLY
this then does the actual shrink. you may need to repeat commands 2 a
3 a couple of times until the filesize stops shrinking.
google or BOL the commands to make sure I have them right, I don't
have a DB handy to check.|||You should learn the basics about backup and restore and based on that set the recovery model for
your database properly. In your case, it seems you have full recover model but you don't perform log
backups. This means that the log is never emptied so the ldf file keeps growing and growing. You can
empty the log file by either setting recover model to simple or by doing:
BACKUP LOG dbname WITH NO_LOG
And then shrink the ldf file (keeping an eye on virtual log file layout, according to
http://www.karaszi.com/SQLServer/info_dont_shrink.asp), to a reasonable size.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Jack" <Jack@.discussions.microsoft.com> wrote in message
news:9038A77D-EE8E-4E41-9FEB-335DB2D62834@.microsoft.com...
> Hi,
> I am working on a Access Sql system where I need to put a new release for a
> system. This system involves transactional replication. Most of new screens
> and code relate to client side sql server and the main server. When I am
> trying to test some functionality on the server (main) side I am getting the
> above error. Right now the main database file is 1. GB while the transaction
> file is 76 GB. The problem is I cannot backup this database on the server as
> it tells the log file is full. So I am not sure how to handle this situation
> without having the ability to have a backup. Any help is appreciated. Thanks

Error message from server: The log file is full. Backup transactio

Hi,
I am working on a Access Sql system where I need to put a new release for a
system. This system involves transactional replication. Most of new screens
and code relate to client side sql server and the main server. When I am
trying to test some functionality on the server (main) side I am getting the
above error. Right now the main database file is 1. GB while the transaction
file is 76 GB. The problem is I cannot backup this database on the server as
it tells the log file is full. So I am not sure how to handle this situation
without having the ability to have a backup. Any help is appreciated. Thanks
On Mar 25, 10:12 am, Jack <J...@.discussions.microsoft.com> wrote:
> Hi,
> I am working on a Access Sql system where I need to put a new release for a
> system. This system involves transactional replication. Most of new screens
> and code relate to client side sql server and the main server. When I am
> trying to test some functionality on the server (main) side I am getting the
> above error. Right now the main database file is 1. GB while the transaction
> file is 76 GB. The problem is I cannot backup this database on the server as
> it tells the log file is full. So I am not sure how to handle this situation
> without having the ability to have a backup. Any help is appreciated. Thanks
try using DBCC SHRINKFILE to shrink the log file in conjunction with
the BACKUP LOG command, use sp_helpfile to find the log files logical
name, something like the following
SP_HELPFILE
this will return the logical name of the log file
DBCC SHRINKFILE (<LogicalName>)
I believe this moves all the data to the start of the file
BACKUP LOG <dbname> WITH TRUNCATE_ONLY
this then does the actual shrink. you may need to repeat commands 2 a
3 a couple of times until the filesize stops shrinking.
google or BOL the commands to make sure I have them right, I don't
have a DB handy to check.

error message

Sometimes when developers try to access to the SQL Server by Enterprise
manager they get an error
"A connection can not be stablished to (local)
Reason: General network error. Check you network documentation.
ConnectionWriter (WrapperWrite ()).
Please verify SQL Server is running and check your SQL Server registration
properties"
I am getting the below error from the event viewer.
I have setup the maximum number of connection to be 3200. But I keep
getting this error continuosly since 8 days ago.
Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17052
Date: 3/21/2006
Time: 1:04:44 PM
User: N/A
Computer: USKFIUSRYESQLD1
Description:
Error: 17809, Severity: 20, State: 1
Could not connect. The maximum number of '30' configured user connections
are already connected. The system administrator can change the maximum to a
higher value using sp_configure.
Data:
0000: 91 45 00 00 14 00 00 00 ?E.....
0008: 10 00 00 00 55 00 53 00 ...U.S.
0010: 4b 00 46 00 49 00 55 00 K.F.I.U.
0018: 53 00 52 00 59 00 45 00 S.R.Y.E.
0020: 53 00 51 00 4c 00 44 00 S.Q.L.D.
0028: 31 00 00 00 00 00 00 00 1......
Please let me know what should I do. I have spoken to the network people to
check the Server itself to see if there is any problem with the network
itself or hardware and they said everything is fine. I keep getting the
Developers to complaint about message above "A Connection can not be stablis
h"
Thanks all for your helpDid you check the run_value using sp_configure? If you
changed the setting, the service requires a restart.
-Sue
On Tue, 21 Mar 2006 10:43:56 -0800, WISTONSQL
<WISTONSQL@.discussions.microsoft.com> wrote:

>Sometimes when developers try to access to the SQL Server by Enterprise
>manager they get an error
>"A connection can not be stablished to (local)
>Reason: General network error. Check you network documentation.
>ConnectionWriter (WrapperWrite ()).
>Please verify SQL Server is running and check your SQL Server registration
>properties"
>I am getting the below error from the event viewer.
>I have setup the maximum number of connection to be 3200. But I keep
>getting this error continuosly since 8 days ago.
>Event Type: Error
>Event Source: MSSQLSERVER
>Event Category: (2)
>Event ID: 17052
>Date: 3/21/2006
>Time: 1:04:44 PM
>User: N/A
>Computer: USKFIUSRYESQLD1
>Description:
>Error: 17809, Severity: 20, State: 1
>Could not connect. The maximum number of '30' configured user connections
>are already connected. The system administrator can change the maximum to a
>higher value using sp_configure.
>Data:
>0000: 91 45 00 00 14 00 00 00 ?E.....
>0008: 10 00 00 00 55 00 53 00 ...U.S.
>0010: 4b 00 46 00 49 00 55 00 K.F.I.U.
>0018: 53 00 52 00 59 00 45 00 S.R.Y.E.
>0020: 53 00 51 00 4c 00 44 00 S.Q.L.D.
>0028: 31 00 00 00 00 00 00 00 1......
>Please let me know what should I do. I have spoken to the network people t
o
>check the Server itself to see if there is any problem with the network
>itself or hardware and they said everything is fine. I keep getting the
>Developers to complaint about message above "A Connection can not be stabli
sh"
>Thanks all for your help|||Hi Sue:
Thanks for your response,
Yes, I reboot the system couple times and still I am having the problem,
today the problem became worst. I am going to deploy SQL Server SP4 - What d
o
you think?
"Sue Hoegemeier" wrote:

> Did you check the run_value using sp_configure? If you
> changed the setting, the service requires a restart.
> -Sue
> On Tue, 21 Mar 2006 10:43:56 -0800, WISTONSQL
> <WISTONSQL@.discussions.microsoft.com> wrote:
>
>|||When you get the error:
Could not connect. The maximum number of '30' configured
user connections are already connected.
you really should run sp_configure to view what you actually
have set for user connections.
If you have been adjusting settings, you may want to make
sure you really have everything set back to the defaults.
The help topic: Setting Configuration Options
lists all the settings and the defaults.
-Sue
On Wed, 22 Mar 2006 16:33:27 -0800, WISTONSQL
<WISTONSQL@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>Hi Sue:
>Thanks for your response,
>Yes, I reboot the system couple times and still I am having the problem,
>today the problem became worst. I am going to deploy SQL Server SP4 - What
do
>you think?
>"Sue Hoegemeier" wrote:
>

error message

Sometimes when developers try to access to the SQL Server by Enterprise
manager they get an error
"A connection can not be stablished to (local)
Reason: General network error. Check you network documentation.
ConnectionWriter (WrapperWrite ()).
Please verify SQL Server is running and check your SQL Server registration
properties"
I am getting the below error from the event viewer.
I have setup the maximum number of connection to be 3200. But I keep
getting this error continuosly since 8 days ago.
Event Type:Error
Event Source:MSSQLSERVER
Event Category:(2)
Event ID:17052
Date:3/21/2006
Time:1:04:44 PM
User:N/A
Computer:USKFIUSRYESQLD1
Description:
Error: 17809, Severity: 20, State: 1
Could not connect. The maximum number of '30' configured user connections
are already connected. The system administrator can change the maximum to a
higher value using sp_configure.
Data:
0000: 91 45 00 00 14 00 00 00 ?E.....
0008: 10 00 00 00 55 00 53 00 ...U.S.
0010: 4b 00 46 00 49 00 55 00 K.F.I.U.
0018: 53 00 52 00 59 00 45 00 S.R.Y.E.
0020: 53 00 51 00 4c 00 44 00 S.Q.L.D.
0028: 31 00 00 00 00 00 00 00 1......
Please let me know what should I do. I have spoken to the network people to
check the Server itself to see if there is any problem with the network
itself or hardware and they said everything is fine. I keep getting the
Developers to complaint about message above "A Connection can not be stablish"
Thanks all for your help
Did you check the run_value using sp_configure? If you
changed the setting, the service requires a restart.
-Sue
On Tue, 21 Mar 2006 10:43:56 -0800, WISTONSQL
<WISTONSQL@.discussions.microsoft.com> wrote:

>Sometimes when developers try to access to the SQL Server by Enterprise
>manager they get an error
>"A connection can not be stablished to (local)
>Reason: General network error. Check you network documentation.
>ConnectionWriter (WrapperWrite ()).
>Please verify SQL Server is running and check your SQL Server registration
>properties"
>I am getting the below error from the event viewer.
>I have setup the maximum number of connection to be 3200. But I keep
>getting this error continuosly since 8 days ago.
>Event Type:Error
>Event Source:MSSQLSERVER
>Event Category:(2)
>Event ID:17052
>Date:3/21/2006
>Time:1:04:44 PM
>User:N/A
>Computer:USKFIUSRYESQLD1
>Description:
>Error: 17809, Severity: 20, State: 1
>Could not connect. The maximum number of '30' configured user connections
>are already connected. The system administrator can change the maximum to a
>higher value using sp_configure.
>Data:
>0000: 91 45 00 00 14 00 00 00 ?E.....
>0008: 10 00 00 00 55 00 53 00 ...U.S.
>0010: 4b 00 46 00 49 00 55 00 K.F.I.U.
>0018: 53 00 52 00 59 00 45 00 S.R.Y.E.
>0020: 53 00 51 00 4c 00 44 00 S.Q.L.D.
>0028: 31 00 00 00 00 00 00 00 1......
>Please let me know what should I do. I have spoken to the network people to
>check the Server itself to see if there is any problem with the network
>itself or hardware and they said everything is fine. I keep getting the
>Developers to complaint about message above "A Connection can not be stablish"
>Thanks all for your help
|||Hi Sue:
Thanks for your response,
Yes, I reboot the system couple times and still I am having the problem,
today the problem became worst. I am going to deploy SQL Server SP4 - What do
you think?
"Sue Hoegemeier" wrote:

> Did you check the run_value using sp_configure? If you
> changed the setting, the service requires a restart.
> -Sue
> On Tue, 21 Mar 2006 10:43:56 -0800, WISTONSQL
> <WISTONSQL@.discussions.microsoft.com> wrote:
>
>
|||When you get the error:
Could not connect. The maximum number of '30' configured
user connections are already connected.
you really should run sp_configure to view what you actually
have set for user connections.
If you have been adjusting settings, you may want to make
sure you really have everything set back to the defaults.
The help topic: Setting Configuration Options
lists all the settings and the defaults.
-Sue
On Wed, 22 Mar 2006 16:33:27 -0800, WISTONSQL
<WISTONSQL@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>Hi Sue:
>Thanks for your response,
>Yes, I reboot the system couple times and still I am having the problem,
>today the problem became worst. I am going to deploy SQL Server SP4 - What do
>you think?
>"Sue Hoegemeier" wrote: