"SQL Server does not exist or access denied." after installing XP SP2

Hi!

I just installed Windows XP Service Pack 2 on my pc and I cannot make my asp.net applications access any database any more.

I tried starting the application up from the debugger in vs.net, but I got the same behaviour: I can open the login page but as soon as the application tries to connect to SQLServer I get the "SQL Server does not exist or access denied." error message.

I'm trying to connect with trusted_connection.

Can you guys help me out?Try this Microsoft KB article:

http://support.microsoft.com/default.aspx?kbid=839269|||Hi TechMickey,

Did you find a solution to the problem? As you remember I have the same problem and it is still not working.|||Hi bws,

no, I just removed sp2 :-(|||So you took the drastic step. I disabled the firewall but without improvement. I will do like you, get rid of the whole sp2-thing. until I see a solution.

"Hide Duplicates" within Details Grouping

I'm having problems using the "Hide Duplicates" function within the Details
Grouping of a table in a report (using RS SP2, SQL Server 2000, Visual Studio
2003).
The details grouping has two rows, set out as follows:
| CallFlow Name |
| | Outcome Type | Grammar Type | Meaning | Totals
There are about 10 different "CallFlows", each of which is displayed as
above. There are several possible "Outcome Types"(Success, Fail, Hangup etc),
and I want to prevent duplicates within the scope of the Callflow as shown
below:
| CallFlow Name 1 |
| | Success ...
| | Success ...
| | Success ...
The problem is, when setting "Hide Duplicates" for "Outcome Type", it hides
*ALL* of the duplicated information even in the next Callflow. Is there a
conditional expression or formatting that can be applied to this field so
that duplicates are only hidden for that particular table?
ThanksAll the fields should be in one row of the report layout table.
| CallFlow Name | Outcome Type | Grammar Type | Meaning | Totals
In the table's properties, add a group for the CallFlow field.
In the CallFlow cell's properties, click on the Hide Duplicates dropdown
and select the new group created.
GeoSynch
"Laura-Anne" <Laura-Anne@.discussions.microsoft.com> wrote in message
news:B64F7CCE-F9EB-46C1-9C95-87012913AD82@.microsoft.com...
> I'm having problems using the "Hide Duplicates" function within the Details
> Grouping of a table in a report (using RS SP2, SQL Server 2000, Visual Studio
> 2003).
> The details grouping has two rows, set out as follows:
> | CallFlow Name |
> | | Outcome Type | Grammar Type | Meaning | Totals
> There are about 10 different "CallFlows", each of which is displayed as
> above. There are several possible "Outcome Types"(Success, Fail, Hangup etc),
> and I want to prevent duplicates within the scope of the Callflow as shown
> below:
> | CallFlow Name 1 |
> | | Success ...
> | | Success ...
> | | Success ...
> The problem is, when setting "Hide Duplicates" for "Outcome Type", it hides
> *ALL* of the duplicated information even in the next Callflow. Is there a
> conditional expression or formatting that can be applied to this field so
> that duplicates are only hidden for that particular table?
> Thanks
>|||That worked perfectly - thank you very much!
"GeoSynch" wrote:
> All the fields should be in one row of the report layout table.
> | CallFlow Name | Outcome Type | Grammar Type | Meaning | Totals
> In the table's properties, add a group for the CallFlow field.
> In the CallFlow cell's properties, click on the Hide Duplicates dropdown
> and select the new group created.
>
> GeoSynch
>
> "Laura-Anne" <Laura-Anne@.discussions.microsoft.com> wrote in message
> news:B64F7CCE-F9EB-46C1-9C95-87012913AD82@.microsoft.com...
> > I'm having problems using the "Hide Duplicates" function within the Details
> > Grouping of a table in a report (using RS SP2, SQL Server 2000, Visual Studio
> > 2003).
> >
> > The details grouping has two rows, set out as follows:
> >
> > | CallFlow Name |
> > | | Outcome Type | Grammar Type | Meaning | Totals
> >
> > There are about 10 different "CallFlows", each of which is displayed as
> > above. There are several possible "Outcome Types"(Success, Fail, Hangup etc),
> > and I want to prevent duplicates within the scope of the Callflow as shown
> > below:
> >
> > | CallFlow Name 1 |
> > | | Success ...
> > | | Success ...
> > | | Success ...
> >
> > The problem is, when setting "Hide Duplicates" for "Outcome Type", it hides
> > *ALL* of the duplicated information even in the next Callflow. Is there a
> > conditional expression or formatting that can be applied to this field so
> > that duplicates are only hidden for that particular table?
> >
> > Thanks
> >
>
>

"File not in a recognizeable format" when rendering to excel

I am using a WinXP SP2 machine with SQL2000 SP4, and using Reporting
Services SP2 when I get "File not in a recognizeable format" when
rendering to excel. Same goes for trying to render to PDF.
The weird thing is that on a virtual I have with Reporting Services
RTM, the excel opens fine...so I don't know what is going on.
The way I am generating the report is by manually creating a
request/response, adding on the POST vars, and then writing the output
to the browser (changing the content-type to excel, pdf, etc). As I
said, with the RTM version, the excel generates fine, but with SP2 it
doesnt.
Here are the parameters that I am adding onto the URL when I make the
request, along with my custom params.
//SQL REPORTING SERVICES SPECIAL PARAMS
sb.Append("&rs:Command=Render");
sb.Append("&rs:Format=" + exportType);
sb.Append("&rc:Parameters=false");
sb.Append("&rc:Toolbar=false&rs:Encoding=ASCII&rc:NoHeader=true");
I then I generate and return the request with the code below
(GeneratePostData() basically just creates the POST vars from above)
public static string generateReport(string url)
{
String result = "";
//get the data to post.
string postData = GeneratePostData();
System.IO.StreamWriter myWriter = null;
HttpWebRequest objRequest = (HttpWebRequest)WebRequest.Create(url);
objRequest.PreAuthenticate = true;
// Way 1:
//objRequest.Credentials = CredentialCache.DefaultCredentials;
// Way 2:
objRequest.Credentials = new
NetworkCredential(REPORT_USER,REPORT_PASS,REPORT_DOMAIN);
objRequest.Method = "POST";
objRequest.ContentLength = postData.Length;
objRequest.ContentType = "application/x-www-form-urlencoded";
try
{
myWriter = new
System.IO.StreamWriter(objRequest.GetRequestStream());
myWriter.Write(postData);
}
catch (Exception e)
{
return e.Message;
}
finally
{
myWriter.Close();
}
try
{
HttpWebResponse objResponse = (HttpWebResponse)objRequest.GetResponse();
using(System.IO.StreamReader sr = new
System.IO.StreamReader(objResponse.GetResponseStream()) )
{
result = sr.ReadToEnd();
// Close and clean up the StreamReader
sr.Close();
}
}
catch (Exception e)
{
return "An error occured while generating your report.\n" +
e.Message;
}
return result;
}
anyone have any ideas/things I can try because I am at a loss. Thanks
in advance.I figured out my problem.
I was taking the stream reader and passing the results back to the
output stream and writing it out just using Response.Write. This
worked fine for Reporting Svcs RTM, but NOT for SP2.
After going through various postings, I gather a few ways that others
did similar web request/response calls and found that if I just passed
the raw response stream and wrote it out with
Response.outputstream.write that it worked for BOTH RTM and SP2..
System.IO.Stream rs =ReportBuilder.generateReportStream(ReportBuilder.ReportViewerFullPath);
Byte[] read = new Byte[1024];
int count = rs.Read(read, 0, read.Length);
while(count > 0)
{
Response.OutputStream.Write(read, 0, count);
count = rs.Read(read, 0, count);
}

"Custom Reports..." grayed out, SP2 (latest) installed

What am I missing, here? The "Custom Reports..." context menu appears, but
is grayed out, and no "Standard Reports" context menu item is there. I've
found no reference to additional steps to get these reports enabled/visible.
Help?
thanks,Where exactly you see all these things ?
Amarnath
"Stan Spotts [Computer Aid, Inc]" wrote:
> What am I missing, here? The "Custom Reports..." context menu appears, but
> is grayed out, and no "Standard Reports" context menu item is there. I've
> found no reference to additional steps to get these reports enabled/visible.
> Help?
> thanks,|||In SQL Server Management Studio.
"Amarnath" wrote:
> Where exactly you see all these things ?
> Amarnath
> "Stan Spotts [Computer Aid, Inc]" wrote:
> > What am I missing, here? The "Custom Reports..." context menu appears, but
> > is grayed out, and no "Standard Reports" context menu item is there. I've
> > found no reference to additional steps to get these reports enabled/visible.
> >
> > Help?
> >
> > thanks,

Hello All,

I have an SQL 2000 sp4 default instance.
On windows server 2003 sp2 machine that is joined to a domain.
This windows is not the domain controller.

There is a domain account domain\user.
This domain account is a member of the Administrators group locally in the windows.
Also this domain account is a member of SysAdmin fixed server role of the SQL Server instance.
The MSSQLSERVER service is logged in by this domain account.
The SQLSERVERAGENT service is also logged in by this domain account.

Office 2007 (including outlook 2003) is installed on the same windows server machine that SQL resides in.

Lotus notes cloient 6.5 also installed on the same windows server machine that SQL resides in.

In Control Panel - Mail - Profiles: Outlook is the profile used.

In enterprise manager --> Support Services --> SQL Mail --> Properties --> I wrote Outlook in the profile name --> then click "Test" --> I encounter this error: "Error 18025: xp_test_mapi_profile: failed with mail error 0x80040111"

I looked at

http://support.microsoft.com/?id=263556

I could not figured it out

Any help please?

Thanks,

Ven

You need a mapi email client such as Outlook 2000.

I have around 17 SQL/Server 2000's using Domino 6.5 email accounts. Here is the scoop:

Log on to the server as the account that is used for the SQL Service account and install Outlook 2000 (with no service pack). Launch Outlook 2000 and create a mail profile that points to your Domino server. Call this email account SQLMail. Create another Outlook 2000 profile with the name SQLAgentMail and test it (this can be the same Domino account). Then log off the server and log back on using the login account that you normally run the server with. Restart SQL Server (and SQL Server Agent) and then the mapi email profiles created earlier will be available. Set SQLMail to use SQLMail profile and then set SQL Server Agent mail to use SQLAgentMail profile. That's it!

DeWayne

|||

-

|||

DeWayne,

Thanks for your help.

I have other question:

While am setting up SQLMail to use SQLMail profile and then set SQL Server Agent mail to use SQLAgentMail profile.

Receiving the following error.

Error 22022QLServerAgentError: Unable to get the default MAPI Address Book due to MAPI error 271: An error occurred while attempting to open the Window Address Book. Please specify a default mail delivery location in you profile.

If I try to create MAPI profile IBM Lotus Domino Access for Microsoft Outlook - create - new profile through getting the below error.

Failed to create new MAPI profile. Error creating personal Folders service

Note: This error can be caused by an incorrect configuration of out look 2000. If you are using outlook 2000, Please verify that is running in Corporate/Workgroup Mode.

Setup encountered an error and failed to create a MAPI profile.

You will need to reinstall IBM Lotus Domino Access for Microsoft Outlook

(Already we removed and reinstalled)

Any help please?

Ven

|||

DeWayne,

Sorry for the inconvenience,

Restarted SQL Server (and SQL Server Agent) ,the mapi email profiles created earlier still not available.

Can you please help me?

|||

Sure!

You don't need the Notes client installed on the Server at all as you will be using a POP3 email account to connect to the Domino Server (at least that is the way that I run it.)

Sign back on as the SQL Server service account then launch Outlook 2000. Click Tools, Options, click the Mail Services Tab, then click Reconfigure Mail Support and select the Corporate Workgroup option. You may have to setup the mail profile/accounts again if needed (choose POP3 when creating the mail accounts). Be sure to set Outlook to use each profile that you created and launch Outlook and click send/receive to test the email accounts.) Then logoff and sign back in as the normal Server user then restart SQL Server again...

|||

DeWayne,

Thanks you so much. It is working now.

I have other question.

we have five different sql servers.

Is it okif I use the same ( single )mail box for different profiles? instead of creating different mail box on each server?

Or does it works like a mail realy?.

Please help?

Thanks,

Ven

|||

Ven,

I create a new email account for each Server so that any emails from a SQL Server are easily identified. For example, a server named "Boston" I would create an email account named "Boston Server". If SQL is only SENDING emails then you could use one email box for everything; however, I would not want to set up my environment that way...

p.s. I am glad that everything is working correctly!!!

DeWayne

Hello All,

I have an SQL 2000 sp4 default instance.
On windows server 2003 sp2 machine that is joined to a domain.
This windows is not the domain controller.

There is a domain account domain\user.
This domain account is a member of the Administrators group locally in the windows.
Also this domain account is a member of SysAdmin fixed server role of the SQL Server instance.
The MSSQLSERVER service is logged in by this domain account.
The SQLSERVERAGENT service is also logged in by this domain account.

Office 2007 (including outlook 2003) is installed on the same windows server machine that SQL resides in.

Lotus notes cloient 6.5 also installed on the same windows server machine that SQL resides in.

In Control Panel - Mail - Profiles: Outlook is the profile used.

In enterprise manager --> Support Services --> SQL Mail --> Properties --> I wrote Outlook in the profile name --> then click "Test" --> I encounter this error: "Error 18025: xp_test_mapi_profile: failed with mail error 0x80040111"

I looked at

http://support.microsoft.com/?id=263556

I could not figured it out

Any help please?

Thanks,

Ven

You need a mapi email client such as Outlook 2000.

I have around 17 SQL/Server 2000's using Domino 6.5 email accounts. Here is the scoop:

Log on to the server as the account that is used for the SQL Service account and install Outlook 2000 (with no service pack). Launch Outlook 2000 and create a mail profile that points to your Domino server. Call this email account SQLMail. Create another Outlook 2000 profile with the name SQLAgentMail and test it (this can be the same Domino account). Then log off the server and log back on using the login account that you normally run the server with. Restart SQL Server (and SQL Server Agent) and then the mapi email profiles created earlier will be available. Set SQLMail to use SQLMail profile and then set SQL Server Agent mail to use SQLAgentMail profile. That's it!

DeWayne

|||

-

|||

DeWayne,

Thanks for your help.

I have other question:

While am setting up SQLMail to use SQLMail profile and then set SQL Server Agent mail to use SQLAgentMail profile.

Receiving the following error.

Error 22022QLServerAgentError: Unable to get the default MAPI Address Book due to MAPI error 271: An error occurred while attempting to open the Window Address Book. Please specify a default mail delivery location in you profile.

If I try to create MAPI profile IBM Lotus Domino Access for Microsoft Outlook - create - new profile through getting the below error.

Failed to create new MAPI profile. Error creating personal Folders service

Note: This error can be caused by an incorrect configuration of out look 2000. If you are using outlook 2000, Please verify that is running in Corporate/Workgroup Mode.

Setup encountered an error and failed to create a MAPI profile.

You will need to reinstall IBM Lotus Domino Access for Microsoft Outlook

(Already we removed and reinstalled)

Any help please?

Ven

|||

DeWayne,

Sorry for the inconvenience,

Restarted SQL Server (and SQL Server Agent) ,the mapi email profiles created earlier still not available.

Can you please help me?

|||

Sure!

You don't need the Notes client installed on the Server at all as you will be using a POP3 email account to connect to the Domino Server (at least that is the way that I run it.)

Sign back on as the SQL Server service account then launch Outlook 2000. Click Tools, Options, click the Mail Services Tab, then click Reconfigure Mail Support and select the Corporate Workgroup option. You may have to setup the mail profile/accounts again if needed (choose POP3 when creating the mail accounts). Be sure to set Outlook to use each profile that you created and launch Outlook and click send/receive to test the email accounts.) Then logoff and sign back in as the normal Server user then restart SQL Server again...

|||

DeWayne,

Thanks you so much. It is working now.

I have other question.

we have five different sql servers.

Is it okif I use the same ( single )mail box for different profiles? instead of creating different mail box on each server?

Or does it works like a mail realy?.

Please help?

Thanks,

Ven

|||

Ven,

I create a new email account for each Server so that any emails from a SQL Server are easily identified. For example, a server named "Boston" I would create an email account named "Boston Server". If SQL is only SENDING emails then you could use one email box for everything; however, I would not want to set up my environment that way...

p.s. I am glad that everything is working correctly!!!

DeWayne