Can't get exclusive access

While attempting to restore a db, I get the following error message:
"RESTORE DATABASE is terminating abnormally.
Exclusive access could not be obtained because the database is in use."
But looking at Current Activity in EM, I see nothing logged into the
database. The database I am restoring to is set to Single-User. Any
suggestions?
SQL 2000, sp4
Thanks,
SteveRunning the statement first
ALTER DATABASE <Nameofthedb> SET SINGLE_USER with rollback immediate
If you want to do that from Query Analyzer, make sure that you cursor is NOT
positioned on the DB node you want to restore.
--
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"Steve Deering" <Steve@.vin.com> schrieb im Newsbeitrag
news:1118060114.644682.280310@.g43g2000cwa.googlegroups.com...
> While attempting to restore a db, I get the following error message:
> "RESTORE DATABASE is terminating abnormally.
> Exclusive access could not be obtained because the database is in use."
> But looking at Current Activity in EM, I see nothing logged into the
> database. The database I am restoring to is set to Single-User. Any
> suggestions?
> SQL 2000, sp4
> Thanks,
> Steve
>|||If it still complains, disconnect all your EM sessions.
"Steve Deering" <Steve@.vin.com> wrote in message
news:1118060114.644682.280310@.g43g2000cwa.googlegroups.com...
> While attempting to restore a db, I get the following error message:
> "RESTORE DATABASE is terminating abnormally.
> Exclusive access could not be obtained because the database is in use."
> But looking at Current Activity in EM, I see nothing logged into the
> database. The database I am restoring to is set to Single-User. Any
> suggestions?
> SQL 2000, sp4
> Thanks,
> Steve
>|||Hi,
Try the below:-
1. From Query analyzer set the database to SINLE USER.
USE MASTER
GO
ALTER DATABASE <DBNAME> SET SINGLE_USER with rollback immediate
2. Restore the database
RESTORE DATABASE <DBNAME> FROM DISK='FILENAME WITH PATH' WITH STATS=10
Incase if the restore still fails then, close the query analyzer fully once
and try the RESTORE DATABASE again.
Thanks
Hari
SQL Server MVP
"Steve Deering" <Steve@.vin.com> wrote in message
news:1118060114.644682.280310@.g43g2000cwa.googlegroups.com...
> While attempting to restore a db, I get the following error message:
> "RESTORE DATABASE is terminating abnormally.
> Exclusive access could not be obtained because the database is in use."
> But looking at Current Activity in EM, I see nothing logged into the
> database. The database I am restoring to is set to Single-User. Any
> suggestions?
> SQL 2000, sp4
> Thanks,
> Steve
>|||Make sure that the database is NOT selected in EM. I've had the exact same
problem and when I selected a different db in EM (master for instance) and
re-ran the restore from Query Analyzer it worked fine.
"Steve Deering" wrote:
> While attempting to restore a db, I get the following error message:
> "RESTORE DATABASE is terminating abnormally.
> Exclusive access could not be obtained because the database is in use."
> But looking at Current Activity in EM, I see nothing logged into the
> database. The database I am restoring to is set to Single-User. Any
> suggestions?
> SQL 2000, sp4
> Thanks,
> Steve
>|||If you are married to using the SQLEM, then here is a trick I often use:
1. Right-click the database.
2. Detach the database. If there are users currently connected, then select
to disconnect them all without notifying them. When it is done, cancel so
you don't actually detach the database.
3. Now, right-click again and set Offline.
Now, you should be able to restore the database without any problems. Yes,
you can restore a database if it is marked offline.
Sometimes, however, you can not click fast enough to set it offline before
another user logs in. You can try this procedures a few time, but at some
point, you are just going to be stuck with script.
I usually use the same syntax as everyone else has shown you, but I like to
set the database offline instead of single-user.
Regardless, before SQL Server 2000, there was no other way to disconnect
users other than scripting out multiple KILL commands to get rid of all the
connections.
Sincerely,
Anthony Thomas
"Steve Deering" <Steve@.vin.com> wrote in message
news:1118060114.644682.280310@.g43g2000cwa.googlegroups.com...
While attempting to restore a db, I get the following error message:
"RESTORE DATABASE is terminating abnormally.
Exclusive access could not be obtained because the database is in use."
But looking at Current Activity in EM, I see nothing logged into the
database. The database I am restoring to is set to Single-User. Any
suggestions?
SQL 2000, sp4
Thanks,
Steve

Can't get exclusive access

While attempting to restore a db, I get the following error message:
"RESTORE DATABASE is terminating abnormally.
Exclusive access could not be obtained because the database is in use."
But looking at Current Activity in EM, I see nothing logged into the
database. The database I am restoring to is set to Single-User. Any
suggestions?
SQL 2000, sp4
Thanks,
Steve
Running the statement first
ALTER DATABASE <Nameofthedb> SET SINGLE_USER with rollback immediate
If you want to do that from Query Analyzer, make sure that you cursor is NOT
positioned on the DB node you want to restore.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"Steve Deering" <Steve@.vin.com> schrieb im Newsbeitrag
news:1118060114.644682.280310@.g43g2000cwa.googlegr oups.com...
> While attempting to restore a db, I get the following error message:
> "RESTORE DATABASE is terminating abnormally.
> Exclusive access could not be obtained because the database is in use."
> But looking at Current Activity in EM, I see nothing logged into the
> database. The database I am restoring to is set to Single-User. Any
> suggestions?
> SQL 2000, sp4
> Thanks,
> Steve
>
|||If it still complains, disconnect all your EM sessions.
"Steve Deering" <Steve@.vin.com> wrote in message
news:1118060114.644682.280310@.g43g2000cwa.googlegr oups.com...
> While attempting to restore a db, I get the following error message:
> "RESTORE DATABASE is terminating abnormally.
> Exclusive access could not be obtained because the database is in use."
> But looking at Current Activity in EM, I see nothing logged into the
> database. The database I am restoring to is set to Single-User. Any
> suggestions?
> SQL 2000, sp4
> Thanks,
> Steve
>
|||Hi,
Try the below:-
1. From Query analyzer set the database to SINLE USER.
USE MASTER
GO
ALTER DATABASE <DBNAME> SET SINGLE_USER with rollback immediate
2. Restore the database
RESTORE DATABASE <DBNAME> FROM DISK='FILENAME WITH PATH' WITH STATS=10
Incase if the restore still fails then, close the query analyzer fully once
and try the RESTORE DATABASE again.
Thanks
Hari
SQL Server MVP
"Steve Deering" <Steve@.vin.com> wrote in message
news:1118060114.644682.280310@.g43g2000cwa.googlegr oups.com...
> While attempting to restore a db, I get the following error message:
> "RESTORE DATABASE is terminating abnormally.
> Exclusive access could not be obtained because the database is in use."
> But looking at Current Activity in EM, I see nothing logged into the
> database. The database I am restoring to is set to Single-User. Any
> suggestions?
> SQL 2000, sp4
> Thanks,
> Steve
>
|||Make sure that the database is NOT selected in EM. I've had the exact same
problem and when I selected a different db in EM (master for instance) and
re-ran the restore from Query Analyzer it worked fine.
"Steve Deering" wrote:

> While attempting to restore a db, I get the following error message:
> "RESTORE DATABASE is terminating abnormally.
> Exclusive access could not be obtained because the database is in use."
> But looking at Current Activity in EM, I see nothing logged into the
> database. The database I am restoring to is set to Single-User. Any
> suggestions?
> SQL 2000, sp4
> Thanks,
> Steve
>
|||If you are married to using the SQLEM, then here is a trick I often use:
1. Right-click the database.
2. Detach the database. If there are users currently connected, then select
to disconnect them all without notifying them. When it is done, cancel so
you don't actually detach the database.
3. Now, right-click again and set Offline.
Now, you should be able to restore the database without any problems. Yes,
you can restore a database if it is marked offline.
Sometimes, however, you can not click fast enough to set it offline before
another user logs in. You can try this procedures a few time, but at some
point, you are just going to be stuck with script.
I usually use the same syntax as everyone else has shown you, but I like to
set the database offline instead of single-user.
Regardless, before SQL Server 2000, there was no other way to disconnect
users other than scripting out multiple KILL commands to get rid of all the
connections.
Sincerely,
Anthony Thomas

"Steve Deering" <Steve@.vin.com> wrote in message
news:1118060114.644682.280310@.g43g2000cwa.googlegr oups.com...
While attempting to restore a db, I get the following error message:
"RESTORE DATABASE is terminating abnormally.
Exclusive access could not be obtained because the database is in use."
But looking at Current Activity in EM, I see nothing logged into the
database. The database I am restoring to is set to Single-User. Any
suggestions?
SQL 2000, sp4
Thanks,
Steve

Can't get exclusive access

While attempting to restore a db, I get the following error message:
"RESTORE DATABASE is terminating abnormally.
Exclusive access could not be obtained because the database is in use."
But looking at Current Activity in EM, I see nothing logged into the
database. The database I am restoring to is set to Single-User. Any
suggestions?
SQL 2000, sp4
Thanks,
SteveRunning the statement first
ALTER DATABASE <Nameofthedb> SET SINGLE_USER with rollback immediate
If you want to do that from Query Analyzer, make sure that you cursor is NOT
positioned on the DB node you want to restore.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"Steve Deering" <Steve@.vin.com> schrieb im Newsbeitrag
news:1118060114.644682.280310@.g43g2000cwa.googlegroups.com...
> While attempting to restore a db, I get the following error message:
> "RESTORE DATABASE is terminating abnormally.
> Exclusive access could not be obtained because the database is in use."
> But looking at Current Activity in EM, I see nothing logged into the
> database. The database I am restoring to is set to Single-User. Any
> suggestions?
> SQL 2000, sp4
> Thanks,
> Steve
>|||If it still complains, disconnect all your EM sessions.
"Steve Deering" <Steve@.vin.com> wrote in message
news:1118060114.644682.280310@.g43g2000cwa.googlegroups.com...
> While attempting to restore a db, I get the following error message:
> "RESTORE DATABASE is terminating abnormally.
> Exclusive access could not be obtained because the database is in use."
> But looking at Current Activity in EM, I see nothing logged into the
> database. The database I am restoring to is set to Single-User. Any
> suggestions?
> SQL 2000, sp4
> Thanks,
> Steve
>|||Hi,
Try the below:-
1. From Query analyzer set the database to SINLE USER.
USE MASTER
GO
ALTER DATABASE <DBNAME> SET SINGLE_USER with rollback immediate
2. Restore the database
RESTORE DATABASE <DBNAME> FROM DISK='FILENAME WITH PATH' WITH STATS=10
Incase if the restore still fails then, close the query analyzer fully once
and try the RESTORE DATABASE again.
Thanks
Hari
SQL Server MVP
"Steve Deering" <Steve@.vin.com> wrote in message
news:1118060114.644682.280310@.g43g2000cwa.googlegroups.com...
> While attempting to restore a db, I get the following error message:
> "RESTORE DATABASE is terminating abnormally.
> Exclusive access could not be obtained because the database is in use."
> But looking at Current Activity in EM, I see nothing logged into the
> database. The database I am restoring to is set to Single-User. Any
> suggestions?
> SQL 2000, sp4
> Thanks,
> Steve
>|||Make sure that the database is NOT selected in EM. I've had the exact same
problem and when I selected a different db in EM (master for instance) and
re-ran the restore from Query Analyzer it worked fine.
"Steve Deering" wrote:

> While attempting to restore a db, I get the following error message:
> "RESTORE DATABASE is terminating abnormally.
> Exclusive access could not be obtained because the database is in use."
> But looking at Current Activity in EM, I see nothing logged into the
> database. The database I am restoring to is set to Single-User. Any
> suggestions?
> SQL 2000, sp4
> Thanks,
> Steve
>|||If you are married to using the SQLEM, then here is a trick I often use:
1. Right-click the database.
2. Detach the database. If there are users currently connected, then select
to disconnect them all without notifying them. When it is done, cancel so
you don't actually detach the database.
3. Now, right-click again and set Offline.
Now, you should be able to restore the database without any problems. Yes,
you can restore a database if it is marked offline.
Sometimes, however, you can not click fast enough to set it offline before
another user logs in. You can try this procedures a few time, but at some
point, you are just going to be stuck with script.
I usually use the same syntax as everyone else has shown you, but I like to
set the database offline instead of single-user.
Regardless, before SQL Server 2000, there was no other way to disconnect
users other than scripting out multiple KILL commands to get rid of all the
connections.
Sincerely,
Anthony Thomas
"Steve Deering" <Steve@.vin.com> wrote in message
news:1118060114.644682.280310@.g43g2000cwa.googlegroups.com...
While attempting to restore a db, I get the following error message:
"RESTORE DATABASE is terminating abnormally.
Exclusive access could not be obtained because the database is in use."
But looking at Current Activity in EM, I see nothing logged into the
database. The database I am restoring to is set to Single-User. Any
suggestions?
SQL 2000, sp4
Thanks,
Steve

Can't Generate SSPI

Hi,
I'm trying to configure a Windows Authentication SQL Server user and I get a
message that the compuetr can;t generate an SSPI connection. The Enterprise
Manager then won't connect to the SQL Server. The VS.NET 2003 enviroment, w
hich is the user preferred
connection enviroment to the SQL Server also won't connect.
The user has SQL Server 2000 Develop edition SP3a installed on the computer
and we are trying to connect to a SQL Server 2000 Enterprise edition SP3a. T
he user also has on his computer VS6 and VS.NET 2003.
Does any one know the cause of this problems?
Thanks,Try these links:
http://www.sqlservercentral.com/col...kb;en-us;811889
Ray Higdon MCSE, MCDBA, CCNA
--
"Shai Goldberg" <gshai(removethis)@.shamir.co.il> wrote in message
news:B52289F3-1E9F-410F-B49C-BCB73C80D1AD@.microsoft.com...
> Hi,
> I'm trying to configure a Windows Authentication SQL Server user and I get
a message that the compuetr can;t generate an SSPI connection. The
Enterprise Manager then won't connect to the SQL Server. The VS.NET 2003
enviroment, which is the user preferred connection enviroment to the SQL
Server also won't connect.
> The user has SQL Server 2000 Develop edition SP3a installed on the
computer and we are trying to connect to a SQL Server 2000 Enterprise
edition SP3a. The user also has on his computer VS6 and VS.NET 2003.
> Does any one know the cause of this problems?
> Thanks,|||Thanks,sql

Cant find User Default database So, I can't Register my server

Occasionally, I disconnect a database. When I try to reconnect it, I get the
message that SQL "can't find the User default database". Typically, I rein
stall the SQL Server software. There must be a better way. Is there an OSQL
command I can use? How
can I recorver from this condition without riinstalling SQL Server?
Thanks, richardYou can run the OSQL command-line utility to specify an alternate database
context and execute sp_defaultdb to change the default database for a
login. For example:
OSQL -E -d master -Q"sp_defaultdb 'MyLogin', 'MyDatabase'"
Hope this helps.
Dan Guzman
SQL Server MVP
"Richard Muschamp" <dick@.custommicro.com> wrote in message
news:23D9DDF2-EE56-4B8B-8B03-264F006F0B35@.microsoft.com...
> Occasionally, I disconnect a database. When I try to reconnect it, I get
the message that SQL "can't find the User default database". Typically, I
reinstall the SQL Server software. There must be a better way. Is there an
OSQL command I can use? How can I recorver from this condition without
riinstalling SQL Server?
> Thanks, richard|||Hi,
This problem can come due to 2 reasons
1. You have assigned the login a default database and the login do not have
a user assocoated in the default database.
a. Login to Query Analyzer
b. use <dafault databasename>
c. sp_adduser <user name>
d. Assign the required role
2. Database which is given default to the login is dropped or not available.
a. Change the login to point to a different database, Execute the below
from command prompt
b. OSQL -USa -Ppassword -d master -Q"sp_defaultdb 'Login_name', 'New
database which is default'"
Thanks
Hari
MCDBA
"Richard Muschamp" <dick@.custommicro.com> wrote in message
news:23D9DDF2-EE56-4B8B-8B03-264F006F0B35@.microsoft.com...
> Occasionally, I disconnect a database. When I try to reconnect it, I get
the message that SQL "can't find the User default database". Typically, I
reinstall the SQL Server software. There must be a better way. Is there an
OSQL command I can use? How can I recorver from this condition without
riinstalling SQL Server?
> Thanks, richard

Can't find tool

Based on this message referenced in the link below I can't find the file
"FiletoTable.exe" anywhere online. Does anyone know how I can get this file?
"You can also use FiletoTable.exe, a command line utility, to load a trace
file
to a database table so that data in the trace file can be analyzed..."
www.microsoft.com/technet/ prodtechnol/sql/2000/maintain/sqlc2.mspx
Thanks in advance,
Arnold
I don't know about that tool but if you have SQL 2000 you can use:
Select * FROM ::fn_trace_gettable('C:\Traces\TestTrace.trc', default)
See BOL for more details.
Andrew J. Kelly SQL MVP
"Arnold" <Arnold@.discussions.microsoft.com> wrote in message
news:51EF4662-3922-448D-8E46-FCF9F88EDECD@.microsoft.com...
> Based on this message referenced in the link below I can't find the file
> "FiletoTable.exe" anywhere online. Does anyone know how I can get this
> file?
>
> "You can also use FiletoTable.exe, a command line utility, to load a trace
> file
> to a database table so that data in the trace file can be analyzed..."
> www.microsoft.com/technet/ prodtechnol/sql/2000/maintain/sqlc2.mspx
> Thanks in advance,
> Arnold

Can't find PInvoke DLL 'sqlceme30.dll'

I am developing for an ipaq handheld. I just upgraded to Windows Mobile 5.0 and tried to run my application and I get this message.

Can't find PInvoke DLL 'sqlceme30.dll'

I am using a sql Mobile DB and vs2005
found fix here: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=220816&SiteID=1
sql

Cant figure out error message in SQL

Can someone please look at my stored procedure? I am trying to create the following stored procedure, but get the following error
messages:

Msg 102, Level 15, State 1, Procedure InsertWork, Line 3
Incorrect syntax near '7'.
Msg 102, Level 15, State 1, Procedure InsertWork, Line 25
Incorrect syntax near'@.7am8am'.

USE [Work]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[InsertWork]
(
7am8am nvarchar(500),
8am9am nvarchar(500),
9am10am nvarchar(500),
10am11am nvarchar(500),
11am12noon nvarchar(500),
12Noon1pm nvarchar(500),
1pm2pm nvarchar(500),
2pm3pm nvarchar(500),
3pm4pm nvarchar(500),
4pm5pm nvarchar(500),
5pm6pm nvarchar(500),
6pm7pm nvarchar(500),
7pm8pm nvarchar(500),
8pm9pm nvarchar(500),
9pm10pm nvarchar(500),
10pm11pm nvarchar(500),
Notes nvarchar(500),
Date nvarchar(15)
)
AS BEGIN
INSERT INTO WorkDay
VALUES
@.7am8am,
@.8am9am,
@.9am10am,
@.10am11am,
@.11am12Noon,
@.12Noon1pm,
@.1pm2pm,
@.2pm3pm,
@.3pm4pm,
@.4pm5pm,
@.5pm6pm,
@.6pm7pm,
@.7pm8pm,
@.8pm9pm,
@.9pm10pm,
@.10pm11pm,
@.Notes,
@.Date
END

You cannot have variables/parameters names that starts with a number. Try prefixing them with an underscore (quick fix).

|||

johram:

You cannot have variables/parameters names that starts with a number.

Actually you can. The parameters have to start with @. for SQL Server to know its a parameter..

CREATE PROCEDURE [dbo].[InsertWork](@.7am8amnvarchar(500),@.8am9amnvarchar(500),@.9am10amnvarchar(500),@.10am11amnvarchar(500), @.11am12noonnvarchar(500),@.12Noon1pmnvarchar(500),@.1pm2pmnvarchar(500),@.2pm3pmnvarchar(500),@.3pm4pmnvarchar(500),@.4pm5pmnvarchar(500), @.5pm6pmnvarchar(500),@.6pm7pmnvarchar(500),@.7pm8pmnvarchar(500),@.8pm9pmnvarchar(500),@.9pm10pmnvarchar(500), @.10pm11pmnvarchar(500),@.Notesnvarchar(500),@.Datenvarchar(15))AS BEGIN INSERT INTO WorkDayVALUES (@.7am8am, @.8am9am,@.9am10am, @.10am11am, @.11am12Noon,@.12Noon1pm,@.1pm2pm,@.2pm3pm,@.3pm4pm,@.4pm5pm,@.5pm6pm,@.6pm7pm,@.7pm8pm, @.8pm9pm,@.9pm10pm,@.10pm11pm,@.Notes,@.Date )END

|||

ndinakar:

Actually you can. The parameters have to start with @. for SQL Server to know its a parameter..

Of course :-)

Can't enter data

I keep getting the error message "the value you entered is not consistent
with the data type or length of the column" I verified that I am entering the
correct datatype and length. Any ideas why it is not allowing me to enter
data.
Thanks...Hi,
Can you please post the table structure and the data you are trying to
insert.
Thanks
Hari
MCDBA
"mmc" <mmc@.discussions.microsoft.com> wrote in message
news:8D43843F-621B-4BCD-A855-917F592DB1D5@.microsoft.com...
> I keep getting the error message "the value you entered is not consistent
> with the data type or length of the column" I verified that I am entering
the
> correct datatype and length. Any ideas why it is not allowing me to enter
> data.
> Thanks...

Can't enter data

I keep getting the error message "the value you entered is not consistent
with the data type or length of the column" I verified that I am entering the
correct datatype and length. Any ideas why it is not allowing me to enter
data.
Thanks...
Hi,
Can you please post the table structure and the data you are trying to
insert.
Thanks
Hari
MCDBA
"mmc" <mmc@.discussions.microsoft.com> wrote in message
news:8D43843F-621B-4BCD-A855-917F592DB1D5@.microsoft.com...
> I keep getting the error message "the value you entered is not consistent
> with the data type or length of the column" I verified that I am entering
the
> correct datatype and length. Any ideas why it is not allowing me to enter
> data.
> Thanks...

Can't enter data

I keep getting the error message "the value you entered is not consistent
with the data type or length of the column" I verified that I am entering th
e
correct datatype and length. Any ideas why it is not allowing me to enter
data.
Thanks...Hi,
Can you please post the table structure and the data you are trying to
insert.
Thanks
Hari
MCDBA
"mmc" <mmc@.discussions.microsoft.com> wrote in message
news:8D43843F-621B-4BCD-A855-917F592DB1D5@.microsoft.com...
> I keep getting the error message "the value you entered is not consistent
> with the data type or length of the column" I verified that I am entering
the
> correct datatype and length. Any ideas why it is not allowing me to enter
> data.
> Thanks...

Can't email reports

Hello
I'm trying to send the reports in Report Manager by mail, but I have always
the same message -> "Error sending email.
System.Runtime.InteropServices.COMException (0x80040211): The message could
not be sent to the SMTP server. The transport error code was 0x800ccc15. The
server response was not available."
I have installed W XP SP2, and have no firewall
When I installed Rep. Serv. I specified a valid smtp adress.
Can everyone help me pleaseSorry Bruno; it appears you have not included enough information in your
question. How are you trying to send the e-mail? Are you using the
subscription feature in Reporting Services? If so, take a look at the file
RSReportServer.config which is in the ReportServer subfolder of your
Reporting Services installation folder (this in turn is located in the folder
where your SQL Server instance is installed). In this file, there is an XML
element called RSEmailDPConfiguration. Within this element there is a
subelement called SMTPServer. This is where your SMTP server is configured.
Is this configured correctly, i.e. is it pointing to a valid SMTP server like
an Exchange Server?
I am assuming you are trying to send the report using the subscription
feature.
Charles Kangai, MCT, MCDBA
"Bruno" wrote:
> Hello
> I'm trying to send the reports in Report Manager by mail, but I have always
> the same message -> "Error sending email.
> System.Runtime.InteropServices.COMException (0x80040211): The message could
> not be sent to the SMTP server. The transport error code was 0x800ccc15. The
> server response was not available."
> I have installed W XP SP2, and have no firewall
> When I installed Rep. Serv. I specified a valid smtp adress.
>
> Can everyone help me please|||Hello Charles and thanks to help me
Yes, I am using the subcription feature to send email in report manager site.
I follow the suggestion do check the RSReportServer.config and everything is
ok as you can see above:
<RSEmailDPConfiguration>
<SMTPServer>10.250.1.123</SMTPServer> <SMTPServerPort></SMTPServerPort>
<SMTPAccountName></SMTPAccountName>
<SMTPConnectionTimeout></SMTPConnectionTimeout>
<SMTPServerPickupDirectory></SMTPServerPickupDirectory>
<SMTPUseSSL></SMTPUseSSL>
<SendUsing></SendUsing>
<SMTPAuthenticate></SMTPAuthenticate>
<From>reports@.abcorp.com</From>
..................
The smtp adress is valid, because is from the exchange server.
All the sql server services and report services are starting with a domain
account and the sql server uses the mix mode autentication.
When I installed the rep server I selected the sql autentication (sa user)
in credentials to connect to sql server.
When I depoy the reports to Report manager, I can see them perfectly, but
can't send them by mail. The error is always the same "Error sending email.
System.Runtime.InteropServices.COMException (0x80040211): The message could
not be sent to the SMTP server. The transport error code was 0x800ccc15. The
server response was not available"
Can SP2(WinXP) the problem?
Thank you for the help!!!
"Charles Kangai" wrote:
> Sorry Bruno; it appears you have not included enough information in your
> question. How are you trying to send the e-mail? Are you using the
> subscription feature in Reporting Services? If so, take a look at the file
> RSReportServer.config which is in the ReportServer subfolder of your
> Reporting Services installation folder (this in turn is located in the folder
> where your SQL Server instance is installed). In this file, there is an XML
> element called RSEmailDPConfiguration. Within this element there is a
> subelement called SMTPServer. This is where your SMTP server is configured.
> Is this configured correctly, i.e. is it pointing to a valid SMTP server like
> an Exchange Server?
> I am assuming you are trying to send the report using the subscription
> feature.
> Charles Kangai, MCT, MCDBA
> "Bruno" wrote:
> > Hello
> >
> > I'm trying to send the reports in Report Manager by mail, but I have always
> > the same message -> "Error sending email.
> > System.Runtime.InteropServices.COMException (0x80040211): The message could
> > not be sent to the SMTP server. The transport error code was 0x800ccc15. The
> > server response was not available."
> >
> > I have installed W XP SP2, and have no firewall
> > When I installed Rep. Serv. I specified a valid smtp adress.
> >
> >
> > Can everyone help me please|||The problem was in Anti-Virus (McAfee 8 Ent)
"Bruno" wrote:
> Hello
> I'm trying to send the reports in Report Manager by mail, but I have always
> the same message -> "Error sending email.
> System.Runtime.InteropServices.COMException (0x80040211): The message could
> not be sent to the SMTP server. The transport error code was 0x800ccc15. The
> server response was not available."
> I have installed W XP SP2, and have no firewall
> When I installed Rep. Serv. I specified a valid smtp adress.
>
> Can everyone help me please

Can't do backup or restore

Dear all
I'm trying to do a backup from one of my database, but i
always got this message :
The Media Set for database "DBNAME" has 2 family members
but only 1 provided. All member must be provided.
Backup Database is terminated abnormally.
Can some one know what went wrong, cause i don't have any
idea!
Thx alot!
Jack
jackchan@.nedcor.com.hkSeems like the place where you want to backup to (the destination) has been involved in a striped
backup once upon a time. If you no longer want that to be involved in a striped backup, do this
backup using the FORMAT option of the backup command.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"Jack" <jackchan@.nedcor.com.hk> wrote in message news:2c88601c393d2$9badcde0$a601280a@.phx.gbl...
> Dear all
> I'm trying to do a backup from one of my database, but i
> always got this message :
> The Media Set for database "DBNAME" has 2 family members
> but only 1 provided. All member must be provided.
> Backup Database is terminated abnormally.
> Can some one know what went wrong, cause i don't have any
> idea!
> Thx alot!
> Jack
> jackchan@.nedcor.com.hk

Can't detach database

1. Trying to detach in EM but get message 'can't detach while db being
replicated'. OK button is disabled.
2. Replication has been disabled vua Enterprise manager and
sp_removedbreplication.
3. I know that at one time a user had tried unsuccessfullt to set up
replication between this db and a SQLServer installation on her workstation.
I don't know the details of that except that she couldn't get it to work.
4. Is there anything I can do in a system table to clean out everything
related to this replication attempt. so I can detach?
Thanks.
Alan
Alan,
try using sp_dboption to reset the database status:
sp_dboption 'dbname', 'published', 'false'
sp_dboption 'dbname', 'merge publish', 'false'
HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Paul,
Thanks for your reply.
I get following message after
sp_dboption 'Contacts', 'published', 'false'
Server: Msg 208, Level 16, State 1, Procedure sp_dropsubscription, Line 78
Invalid object name 'syssubscriptions'.
Would that be due to fact I tried cleaning out things in EM and
sp_removedbreplication already?
No luck in detaching. EM still says 'Database being replicated - Yes'.
Thanks.
Alan
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:ObTG0HpxEHA.3908@.TK2MSFTNGP12.phx.gbl...
> Alan,
> try using sp_dboption to reset the database status:
> sp_dboption 'dbname', 'published', 'false'
> sp_dboption 'dbname', 'merge publish', 'false'
> HTH,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
|||Alan,
this shouldn't be related. It looks as though things are
very wrong here. If you don't have any other
publications, I'd consider disabling publishing on this
instance and DTS out the data from the database - perhaps
a copydatabase would also work. Then try dropping the
database.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Paul,
Thanks again for your reply.
I will try your suggestions.
Fortunately, it's a test machine. I can even re-intstall SQLServer if I
have to.
If I do re-intall, do you know if there is anything in registry that might
get left over from existing problem?
Needless to say, my client will have to rope in employees who stab around at
things.
Regards,
Alan
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:59a001c4c749$2945b230$a301280a@.phx.gbl...
> Alan,
> this shouldn't be related. It looks as though things are
> very wrong here. If you don't have any other
> publications, I'd consider disabling publishing on this
> instance and DTS out the data from the database - perhaps
> a copydatabase would also work. Then try dropping the
> database.
> Rgds,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>

can't delete log files

Hi every one,
I'm trying to delete one of the two log files from a database but I get the
message "error 5042: the file databse_log cannot be removed because it is
not empty".
I have tried with the commands "backup log databasename with truncate_only"
and "dbcc shrinkfile (filename,emptyfile)" but no luck.
Can anyone tell me how to do it please.
Thanks to all,
Ivan MckenzieUse DBCC LOGINFO to verify that no virtual log files is in use in the ldf file. Google and you will
find articles etc. on how to use the DBCC LOGINFO command.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Ivan Mckenzie" <imck@.inerza.com> wrote in message news:uUT%230SGIGHA.2680@.TK2MSFTNGP09.phx.gbl...
> Hi every one,
> I'm trying to delete one of the two log files from a database but I get the message "error 5042:
> the file databse_log cannot be removed because it is not empty".
> I have tried with the commands "backup log databasename with truncate_only" and "dbcc shrinkfile
> (filename,emptyfile)" but no luck.
> Can anyone tell me how to do it please.
> Thanks to all,
> Ivan Mckenzie
>

cant create object on sql server

When i try to deploy my project or the cube within it i first i get a message 'The server content appears out of date'

then in the error list it tells me 'user does not have permission to create object on [servername] or object does not exist.

Why is this?

Should i create a database first in sql managment studio with a particular name, the name of the project for example. I have tried different impersonation modes...

What login account does analysis services run under when it tries to connect to deploy?

Does it try to create an analysis services database?

Any advise or pointers would be greatly appreciated. Thanks alot.

Jules

The project deployment in BI Dev Studio is happening under your account. You need to have administrative rights ( in many cases ) to deploy your project.

By default all local machine Administrators are also administrators of Analysis Server.

Check check your project properties to see which server you deploy your project to.

You can also open SQL Management studio to see the state your database after your deployed it to Analysis Server.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

Cant create new database / CREATE DATABASE permission denied in database master (error 262

I am using SQL express and Visual web developer on windows Vista.

When I try to create a new database the following message appears.

CREATE DATABASE permission denied in database master (error 262)

I log on to my computer as an administrator.

Help appreciated

Prontonet

How do you login to sql server? Do you use sql authentication? If so, check the account you login with has appropriate permissions. Or are you using windows authentication?

|||

Can you login to database engine and read data anyway??

You need "CREATE DATABASE" permission to create new database. However, to make things easier, i would suggest you use sys_admin permission over your database.Open sql express and click "security"-->Logins, see if your login name is listed there. Rigth click your user name and select "properties", click "server roles" or "User Mappings" to see which role has been assigned to your account. If you are not a sys_admin/db_owner role, login agin using a dbo account(if you have one) and assign you account a sys_admin/dbo permission.

Hope my suggestion helps

Can't Connect with EM

When tring to connect to a remote sql server through EM, I get the following
error message: "SQL Server does not exist or access denied[]ConnectionOpen"
How can I resolve this? Any help is appriciated.
New SQL Server DBA
I believe this would be because the account you are using to access the
Remote SQL Server is not valid, or you do not have the correct password.
Register the server in EM with a valid account and password. A local
administrator account on the Remote SQL Server server has access to SQL
Server. If you are added to the Local Administrators Group, then register
the server in EM using Windows Authentication...Ibelieve this will get you
going.
"Newbie" wrote:

> When tring to connect to a remote sql server through EM, I get the following
> error message: "SQL Server does not exist or access denied[]ConnectionOpen"
> How can I resolve this? Any help is appriciated.
> --
> New SQL Server DBA
|||Newbie (Newbie@.discussions.microsoft.com) writes:
> When tring to connect to a remote sql server through EM, I get the
> following error message: "SQL Server does not exist or access
> denied[]ConnectionOpen"
> How can I resolve this? Any help is appriciated.
This message means that for some reason you cannot reach SQL Server. (Thus
not as NetByTelDBA suggested that your account is not valid.) There are
a number of possible reasons for this. The SQL Server could be down. The
server name you are trying to use does not resolve. You have no connection
to that network. Or you have no permission to that network.
This KN article discusses the matter further:
http://support.microsoft.com/default...EN-US;q328306.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

Can't Connect with EM

When tring to connect to a remote sql server through EM, I get the following
error message: "SQL Server does not exist or access denied[]ConnectionO
pen"
How can I resolve this? Any help is appriciated.
New SQL Server DBAI believe this would be because the account you are using to access the
Remote SQL Server is not valid, or you do not have the correct password.
Register the server in EM with a valid account and password. A local
administrator account on the Remote SQL Server server has access to SQL
Server. If you are added to the Local Administrators Group, then register
the server in EM using Windows Authentication...Ibelieve this will get you
going.
"Newbie" wrote:

> When tring to connect to a remote sql server through EM, I get the followi
ng
> error message: "SQL Server does not exist or access denied[]Connectio
nOpen"
> How can I resolve this? Any help is appriciated.
> --
> New SQL Server DBA|||Newbie (Newbie@.discussions.microsoft.com) writes:
> When tring to connect to a remote sql server through EM, I get the
> following error message: "SQL Server does not exist or access
> denied[]ConnectionOpen"
> How can I resolve this? Any help is appriciated.
This message means that for some reason you cannot reach SQL Server. (Thus
not as NetByTelDBA suggested that your account is not valid.) There are
a number of possible reasons for this. The SQL Server could be down. The
server name you are trying to use does not resolve. You have no connection
to that network. Or you have no permission to that network.
This KN article discusses the matter further:
http://support.microsoft.com/defaul...;EN-US;q328306.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

Can't Connect with EM

When tring to connect to a remote sql server through EM, I get the following
error message: "SQL Server does not exist or access denied[]ConnectionOpen"
How can I resolve this? Any help is appriciated.
--
New SQL Server DBAI believe this would be because the account you are using to access the
Remote SQL Server is not valid, or you do not have the correct password.
Register the server in EM with a valid account and password. A local
administrator account on the Remote SQL Server server has access to SQL
Server. If you are added to the Local Administrators Group, then register
the server in EM using Windows Authentication...Ibelieve this will get you
going.
"Newbie" wrote:
> When tring to connect to a remote sql server through EM, I get the following
> error message: "SQL Server does not exist or access denied[]ConnectionOpen"
> How can I resolve this? Any help is appriciated.
> --
> New SQL Server DBA|||Newbie (Newbie@.discussions.microsoft.com) writes:
> When tring to connect to a remote sql server through EM, I get the
> following error message: "SQL Server does not exist or access
> denied[]ConnectionOpen"
> How can I resolve this? Any help is appriciated.
This message means that for some reason you cannot reach SQL Server. (Thus
not as NetByTelDBA suggested that your account is not valid.) There are
a number of possible reasons for this. The SQL Server could be down. The
server name you are trying to use does not resolve. You have no connection
to that network. Or you have no permission to that network.
This KN article discusses the matter further:
http://support.microsoft.com/default.aspx?scid=KB;EN-US;q328306.
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp