Database Name problem

I have a database server and I have other web server. I want to connect to Microsoft SQL server I connected. My database name has " " space in it line
"My Database" I use php to connect to MSSQL but php dosent see or understand space in Database name... I cant change database name because other sites also uses this database. How can solve this prblem pls help me.Put the database name in brackets. [My Database]

Database Mirror failover from Principal to Mirror

All,
I have two sql servers setup for Data Mirroring. when I do a failover to the
mirror server. The application can not connect to the database Mirror server
that has become the Principal server. I'm using sql authentication for the
application.
I have to drop the user in the Database and recreate it to allow it to
connnect to the database. Below is the error message:
The server principal "nyccs" is not able to access the database "jztest"
under the current security context.
What security context do I have to setup the data Mirror inorder to
automatically failover without any failures.
Thanks,
Naana.
Message posted via http://www.droptable.comHave you read and followed the info here?
http://msdn2.microsoft.com/en-us/library/ms177412.aspx
In specific, check this section:
http://msdn2.microsoft.com/en-us/library/ms366346.aspx
"Naana via droptable.com" wrote:

> All,
> I have two sql servers setup for Data Mirroring. when I do a failover to t
he
> mirror server. The application can not connect to the database Mirror serv
er
> that has become the Principal server. I'm using sql authentication for the
> application.
> I have to drop the user in the Database and recreate it to allow it to
> connnect to the database. Below is the error message:
> The server principal "nyccs" is not able to access the database "jztest"
> under the current security context.
> What security context do I have to setup the data Mirror inorder to
> automatically failover without any failures.
> Thanks,
> Naana.
> --
> Message posted via http://www.droptable.com
>

Database Mail (can't connect to SMTP server)

I'm new to Database Mail and SQL 2005. I have an existing SMTP server (not local) which I'm able to connect to and send mail using Outlook. When I try to connect to the same SMTP server in Database Mail, I get the following error in the Log:

Message
The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 3 (2006-09-20T17:04:21). Exception Message: Could not connect to mail server. (An established connection was aborted by the software in your host machine).
)

No matter what variation I try, I can't connect to the server. I also tried setting up a local SMTP server (the one that comes with IIS). I was able to send mail out successfully from Outlook using this local SMTP server too. However, I get the same error when trying the local server in Database Mail.

This is probably something stupid I'm missing. Any ideas?

I'm using SQL 2005 Developer Edition to test applications on Windows XP Pro.

Thanks,

James

We are experiencing the same issue, same error message but on SQL 2005 Enterprise Edition- (Database Mail).

Thanks,

Carmen

|||

Same here ... i checked the error from

SELECT * FROM msdb.dbo.sysmail_event_log

The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2006-11-15T06:58:44). Exception Message: Could not connect to mail server. (No such host is known). )

But i know my Host is right .

Thanks

Praveen

|||

I had same problem using dbmail on my laptop, but I have figured out what was wrong. The anti-virus program is blocking any port 25 message out, so my dbmail cannot reach my mail server. I have another dbmail on a sql server in the same network segment as the mail server is can send mail without problem. Check with your network admin to see if anything is blocking port 25 message (anti-virus, firewall etc.). By the way, Outlook uses MAPI API to talk to Exchange Server.

Good luck.

Database Mail (can't connect to SMTP server)

I'm new to Database Mail and SQL 2005. I have an existing SMTP server (not local) which I'm able to connect to and send mail using Outlook. When I try to connect to the same SMTP server in Database Mail, I get the following error in the Log:

Message
The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 3 (2006-09-20T17:04:21). Exception Message: Could not connect to mail server. (An established connection was aborted by the software in your host machine).
)

No matter what variation I try, I can't connect to the server. I also tried setting up a local SMTP server (the one that comes with IIS). I was able to send mail out successfully from Outlook using this local SMTP server too. However, I get the same error when trying the local server in Database Mail.

This is probably something stupid I'm missing. Any ideas?

I'm using SQL 2005 Developer Edition to test applications on Windows XP Pro.

Thanks,

James

We are experiencing the same issue, same error message but on SQL 2005 Enterprise Edition- (Database Mail).

Thanks,

Carmen

|||

Same here ... i checked the error from

SELECT * FROM msdb.dbo.sysmail_event_log

The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2006-11-15T06:58:44). Exception Message: Could not connect to mail server. (No such host is known). )

But i know my Host is right .

Thanks

Praveen

|||

I had same problem using dbmail on my laptop, but I have figured out what was wrong. The anti-virus program is blocking any port 25 message out, so my dbmail cannot reach my mail server. I have another dbmail on a sql server in the same network segment as the mail server is can send mail without problem. Check with your network admin to see if anything is blocking port 25 message (anti-virus, firewall etc.). By the way, Outlook uses MAPI API to talk to Exchange Server.

Good luck.

Database Mail (can't connect to SMTP server)

I'm new to Database Mail and SQL 2005. I have an existing SMTP server (not local) which I'm able to connect to and send mail using Outlook. When I try to connect to the same SMTP server in Database Mail, I get the following error in the Log:

Message
The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 3 (2006-09-20T17:04:21). Exception Message: Could not connect to mail server. (An established connection was aborted by the software in your host machine).
)

No matter what variation I try, I can't connect to the server. I also tried setting up a local SMTP server (the one that comes with IIS). I was able to send mail out successfully from Outlook using this local SMTP server too. However, I get the same error when trying the local server in Database Mail.

This is probably something stupid I'm missing. Any ideas?

I'm using SQL 2005 Developer Edition to test applications on Windows XP Pro.

Thanks,

James

We are experiencing the same issue, same error message but on SQL 2005 Enterprise Edition- (Database Mail).

Thanks,

Carmen

|||

Same here ... i checked the error from

SELECT * FROM msdb.dbo.sysmail_event_log

The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2006-11-15T06:58:44). Exception Message: Could not connect to mail server. (No such host is known). )

But i know my Host is right .

Thanks

Praveen

|||

I had same problem using dbmail on my laptop, but I have figured out what was wrong. The anti-virus program is blocking any port 25 message out, so my dbmail cannot reach my mail server. I have another dbmail on a sql server in the same network segment as the mail server is can send mail without problem. Check with your network admin to see if anything is blocking port 25 message (anti-virus, firewall etc.). By the way, Outlook uses MAPI API to talk to Exchange Server.

Good luck.

Database Logon Failed SSRS

Hi All,

My Report Server works find but after apply SQL Server 2005 Service Pack2. I can't connect to ReportServer Database. When Trying to connect from SQL Server Management Studio i get following Page.

TITLE: Connect to Server

Cannot connect to VISTA.

ADDITIONAL INFORMATION:

Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'.
The request failed with the error message:
--
<html>
<head>
<title>
SQL Server Reporting Services
</title><meta name="Generator" content="Microsoft SQL Server Reporting Services 9.00.3054.00" />
<meta name="HTTP Status" content="500" />
<meta name="ProductLocaleID" content="9" />
<meta name="CountryLocaleID" content="1033" />
<style>
BODY {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE: 8pt; COLOR:black}
H1 {FONT-FAMILY:Verdana; FONT-WEIGHT:700; FONT-SIZE:15pt}
LI {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE:8pt; DISPLAY:inline}
.ProductInfo {FONT-FAMILY:Verdana; FONT-WEIGHT:bold; FONT-SIZE: 8pt; COLOR:gray}
A:link {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR3366CC; TEXT-DECORATION:none}
A:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLORFF3300; TEXT-DECORATION:underline}
A:visited {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR3366CC; TEXT-DECORATION:none}
A:visited:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; colorFF3300; TEXT-DECORATION:underline}

</style>
</head><body bgcolor="white">
<h1>
Reporting Services Error<hr width="100%" size="1" color="silver" />
</h1><ul>
<li>The report server cannot open a connection to the report server database. The logon failed. (rsReportServerDatabaseLogonFailed) <a href="http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsReportServerDatabaseLogonFailed&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=9.00.3054.00" target="_blank">Get Online Help</a></li><ul>
<li>For more information about this error navigate to the report server on the local server machine, or enable remote errors</li>
</ul><hr width="100%" size="1" color="silver" /><span class="ProductInfo">SQL Server Reporting Services</span>
</ul>
</body>
--. (Microsoft.SqlServer.Management.UI.RSClient)

BUTTONS:

OK

Colud anyone help me to resolve this issue please?

Thank you very much.

Regards,

Balwant Patel

Try using the Reporting Services Configuration Utility (Database tab) to generate a database script and apply this script manually to your ReportServer database.|||

Did you just put on SP2? I had the same error very shortly after I put either SP2 or a hotfix (can't remember which), and it was fixed after a complete system restart and hasn't returned.

|||Make sure that the Service Accoutn the Reporting Server is running under has appropiate permissions to access the Report Server Database.

Jens K. Suessmeyer.

http://www.sqlserver2005.de
|||

Hi Teo,

Thank you very much for your response... I tried with Database script but it doesn't work.

Regards,

Balwant Patel.

|||

Hi gnieboer,

Thank you very much for response...I also restarted my system after apply SQL Server 2005 SP2 but I can't get rid of the problem.

Regards,

Balwant Patel

|||

Hi Suessmeyer,

I check permission on Report Server Database...It is fine

Regards,

Balwant Patel

|||Which account has been granted access to the Report Server database, the ReportService Account (Windows Service) or the ASP_Net Worker process ?

Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

Hi suessmeyer,

I m using Windows Service Account

Regards,

Balwant Patel

|||Make sure that the the ASPNET account is a member of the SQLServer2005ReportingServicesWebServiceUser$<computername> $MSSQLSERVER Windows group and NT Authority\System is a member of the SQLServer2005ReportServerUser$<computername>$MSSQLSERVER group.|||

Hi Teo,

Yes, ASPNET Account & Authority\System are members of above groups...

I dont know what's the problem with it...

Regards,

Balwant Patel.