"Unable To Connect to SQL Server" from Crystal 8.0

Hi All,

I am using Crystal Report 8.0 to create report on MSDE sp3a , but when I try to make connection Natively :
More Data Source->MiCrosoft SQL Server-> [Dialog opens]
then I type the ServerName, UserID and Password.

System hangs for a while, then I get this error :
"Unable To Connect to Sql server MyServer"

BUT IF I create system DSN (ODBC) then create the report, it works.

Why can't I create report Natively on MSDE ??

Thank you very much for any help,
KristWhat are you typing for ServerName? Is this database on a base or named instance? Also, don't it ask you for the database name?|||Hi,
Thanks for your response.

>What are you typing for ServerName?
I type 'XTANTO', it is my computer name, as I can see on service manager.

>Is this database on a base or named instance?
This is a base instance. FYI, this is a test computer, sp many 'install & uninstall' here, previously there is SQL Server personal edition there, but I already uninstalled it.
After that I install 'Client Connectivity only', and there is No way I can uninstall it. Then I install MSDE SP3a. and I get the error.
Does this give us any clue ?

>Also, don't it ask you for the database name?
Only after I type ServerName, UserID and Password correctly.
In this case, it doesn't give me list of database to choose because its error "Unable To Connect to SQL Server"

My last try will be reinstall win 98.
Do you think that will help ?

Thank you for your help,
Krist|||Go to Control Panel/Administrative Tools/Services. There should be a service that starts with MSSQL. Is it started? What is the full name of the service (or all the services that start with MSSQL)?|||Hi,

I am on Win98, there is NO services on control panel.
What else should I try ?

Thank you,
Krist|||Actually, here's a better question. Why are you running this on a Windows 98 machine??? Do a search for SQLScan on http://www.microsoft.com/downloads/details.aspx?FamilyID=9552d43b-04eb-4af9-9e24-6cde4d933600&displaylang=en

Run that on your machine. See what it says the name of the instance is.|||Hi Derrick,
Thanks for keep on helping..

>Actually, here's a better question. Why are you running this on a Windows >98 machine???
We are software developer company, we want to reach as wide market as possible, we want to keep on supporting windows 98.

The docs said Windows 98 is supported. Is there any known issue of MSDE 2000 on WIn 98 ?

Thank you,
Krist|||No that I know of. Did you run that tool on your computer?

"The connection could not be made to the report server......"

My test system is fine (windows 2003, VS.NET, RS). I could suffer the page
https://myserver/reports by using a browser. However, when creating a report
project, I couldn't deploy and got the error message : "The connection could
not be made to the report server https://myserver/reportserver".
Please help me.I am also having similar problems -- I tried reseting the proxy settings in
IE but not helping
"Vu Dawson" wrote:
> My test system is fine (windows 2003, VS.NET, RS). I could suffer the page
> https://myserver/reports by using a browser. However, when creating a report
> project, I couldn't deploy and got the error message : "The connection could
> not be made to the report server https://myserver/reportserver".
> Please help me.|||I was researching this error msg. I don't know if this applies to you.
When you open the browser and navigate to https://myserver/reportserver do
you get a https certificate prompt (yes/no/install cert?). This was the issue
for me... click on Install Certficate and try deploying again.
Good luck!
"Peter" wrote:
> I am also having similar problems -- I tried reseting the proxy settings in
> IE but not helping
> "Vu Dawson" wrote:
> > My test system is fine (windows 2003, VS.NET, RS). I could suffer the page
> > https://myserver/reports by using a browser. However, when creating a report
> > project, I couldn't deploy and got the error message : "The connection could
> > not be made to the report server https://myserver/reportserver".
> > Please help me.

"SQL Server does not exist or access denied" PPC

Hi everybody,
I have a great problem with Sql Server connections in Pocket Pc. When I try
to create a connection with an Sql Server 2000 with Visual Basic.NET 2003 (I
have Windows XP), I receive the error : "SQL Server does not exist or access
denied".
My connection string is something like:
Dim conn as new Sqlconnection("Server=NAMESERVER;Initial Catalog=Aname;User
ID=anID;Password=Apwd")
I've tried to make changes like Server=192.168.1..10 or change the user and
the password, or include the Integrated Security=SSPI with no success.
Could you help me, please?
I have found the solution by myself:
in the connection string, change the server name by his IP. Then
go to "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\SVRNETCN.exe"
and then enable TCP/IP (put TCP/IP in the right square).
Accept changes... Voil!
"Antonio Prados" <antonio.prados@.eutisoftware.com> escribi en el mensaje
news:35bsm3F4iukicU1@.individual.net...
> Hi everybody,
> I have a great problem with Sql Server connections in Pocket Pc. When I
try
> to create a connection with an Sql Server 2000 with Visual Basic.NET 2003
(I
> have Windows XP), I receive the error : "SQL Server does not exist or
access
> denied".
> My connection string is something like:
> Dim conn as new Sqlconnection("Server=NAMESERVER;Initial
Catalog=Aname;User
> ID=anID;Password=Apwd")
> I've tried to make changes like Server=192.168.1..10 or change the user
and
> the password, or include the Integrated Security=SSPI with no success.
> Could you help me, please?
>

"SQL Server does not exist or access denied" PPC

Hi everybody,
I have a great problem with Sql Server connections in Pocket Pc. When I try
to create a connection with an Sql Server 2000 with Visual Basic.NET 2003 (I
have Windows XP), I receive the error : "SQL Server does not exist or access
denied".
My connection string is something like:
Dim conn as new Sqlconnection("Server=NAMESERVER;Initial Catalog=Aname;User
ID=anID;Password=Apwd")
I've tried to make changes like Server=192.168.1..10 or change the user and
the password, or include the Integrated Security=SSPI with no success.
Could you help me, please?I have found the solution by myself:
in the connection string, change the server name by his IP. Then
go to "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\SVRNETCN.exe"
and then enable TCP/IP (put TCP/IP in the right square).
Accept changes... Voil!
"Antonio Prados" <antonio.prados@.eutisoftware.com> escribi en el mensaje
news:35bsm3F4iukicU1@.individual.net...
> Hi everybody,
> I have a great problem with Sql Server connections in Pocket Pc. When I
try
> to create a connection with an Sql Server 2000 with Visual Basic.NET 2003
(I
> have Windows XP), I receive the error : "SQL Server does not exist or
access
> denied".
> My connection string is something like:
> Dim conn as new Sqlconnection("Server=NAMESERVER;Initial
Catalog=Aname;User
> ID=anID;Password=Apwd")
> I've tried to make changes like Server=192.168.1..10 or change the user
and
> the password, or include the Integrated Security=SSPI with no success.
> Could you help me, please?
>

"SQL Server does not exist or access denied" error

I'm trying to create to set up connection between my web application on the server and
the database on another box and getting "SQL Server does not exist or access denied" error.
Both the web server and the database machine are Windows 2003 Server, there's no firewall
enabled, there's mixed authentication enabled on the sql server. The machines are not on the
same domain so I'm using SQL Server authentication from web.config. Here's my connection string:
<add key="ConnectionString" value="Server=sqlboxip;User id=sqlaccountname;Pwd=sqlpass;Initial catalog=dbname">
I've also got <identity impersonate="true"> set in web.config.
Had it the connection working at some stage but then with more tweaking and app reinstall
back square one... Please help!</identity></add>Hi,
Are you able to connect to the SQL Server Database using the same credentials from SQL Server (Enterprise Manager or Query Analyzer?)
Thanks.|||Yes, I can connect to it from my dev box in ASP.NET
|||Did you set the connection string of your connection on that page of the app?

I put this in the page load.
this.cnMainConnection.ConnectionString = System.Configuration.ConfigurationSettings.AppSettings["ConnectionsString"].ToString();

|||Hi,
Ok, can you post the code which you are trying to execute.
Thanks.

"Oracle Not Available" error from SQL

We have a DTS package utilizing an ODBC connection to and Oracle database to run a few updates. I can TNSPING the Oracle instance but get the error Ora-01034 ORACLE not available when trying to run the package.
Any ideas?DTS packages can run as scheduled tasks, on the server itself, or from a workstation. They may or may not have the same NT Credentials. My guess would be that you're running the task from two different machines (a workstation and a server), where one has Oracle connectivity and the other does not.

-PatP|||Pat, Thanks for the reply.

This is all running from our SQL server and is scheduled from there. When i am looking at the DTS package, specifically the connection i can not even close it without getting the error.|||Have you rebooted NT since you installed the Oracle drivers on your server?

-PatP|||We have been utilizing the Microsoft ODBC for Oracle drivers.|||Have you tried running xp_cmdshell stored procedure from sql server with something like 'tnsping oracle_server'?

exec master..xp_cmdshell 'tnsping oracle_server_name'

what is the result? it could help to determine the source of problem

btw we have been using microsoft ole db provider for oracle for two years in dts packages and it's absolutely problemless. but only for selects. mojza

"ORA-03114: not connected to ORACLE".

In a windows service (.NET) on unplugging network cable it use to loose
connection to oracle database.
Once the network connection was up it was found that the service was unable
to restore its connection to oracle database.
The conclusion that we drew after doing R&D was that, the connection pool
was keeping the bad connection in connection pool on network disconnection
which resulted in the service to use those bad connection and keep throwing
exception “not connected to Oracle”.
On Microsoft site there is a mention of Hot Fix. Where can we get this?
http://support.microsoft.com/default...b;en-us;830173
Is there any way we can solve this problem without applying the HOT FIX.
Architect
eBusiness & Intranet
You will need to contact Microsoft PSS Developer Support (contact information
is on the kb article you referenced.) There are two versions of the hotfix,
..NET RTM and .NET 1.1 SP1.
"WEB_CMA" wrote:
> In a windows service (.NET) on unplugging network cable it use to loose
> connection to oracle database.
> Once the network connection was up it was found that the service was unable
> to restore its connection to oracle database.
> The conclusion that we drew after doing R&D was that, the connection pool
> was keeping the bad connection in connection pool on network disconnection
> which resulted in the service to use those bad connection and keep throwing
> exception “not connected to Oracle”.
> On Microsoft site there is a mention of Hot Fix. Where can we get this?
> http://support.microsoft.com/default...b;en-us;830173
>
> Is there any way we can solve this problem without applying the HOT FIX.
> --
> Architect
> eBusiness & Intranet
>

"ORA-03114: not connected to ORACLE".

In a windows service (.NET) on unplugging network cable it use to loose
connection to oracle database.
Once the network connection was up it was found that the service was unable
to restore its connection to oracle database.
The conclusion that we drew after doing R&D was that, the connection pool
was keeping the bad connection in connection pool on network disconnection
which resulted in the service to use those bad connection and keep throwing
exception “not connected to Oracle”.
On Microsoft site there is a mention of Hot Fix. Where can we get this'
http://support.microsoft.com/defaul...kb;en-us;830173
Is there any way we can solve this problem without applying the HOT FIX.
Architect
eBusiness & IntranetYou will need to contact Microsoft PSS Developer Support (contact informatio
n
is on the kb article you referenced.) There are two versions of the hotfix,
.NET RTM and .NET 1.1 SP1.
"WEB_CMA" wrote:
> In a windows service (.NET) on unplugging network cable it use to loose
> connection to oracle database.
> Once the network connection was up it was found that the service was unabl
e
> to restore its connection to oracle database.
> The conclusion that we drew after doing R&D was that, the connection pool
> was keeping the bad connection in connection pool on network disconnection
> which resulted in the service to use those bad connection and keep throwin
g
> exception “not connected to Oracle”.
> On Microsoft site there is a mention of Hot Fix. Where can we get this'
> http://support.microsoft.com/defaul...kb;en-us;830173
>
> Is there any way we can solve this problem without applying the HOT FIX.
> --
> Architect
> eBusiness & Intranet
>

"Open Table Window" is read-only under SQL Query Analyzer

I have installed SQL Server 2000 with option "Client Tools Only"
I try to edit data using SQL Query Analyzer with Trusted Connection. I click on 'Open' of right-click on table objects. A "Open Table Window" is opened as read-only!!! "Add" and "Delete" are grey out!! I can't edit data.
I am trying to edit data using Server Explorer under Microsoft .NET with Trusted Connection. It works!!!
Help, Help!
Maybe the table does not have a Primary Key, check this first.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"Happy Programmer" <anonymous@.discussions.microsoft.com> wrote in message
news:9D59D138-BFAE-4CAB-A2C1-FF535B42F2C7@.microsoft.com...
> I have installed SQL Server 2000 with option "Client Tools Only"
> I try to edit data using SQL Query Analyzer with Trusted Connection. I
click on 'Open' of right-click on table objects. A "Open Table Window" is
opened as read-only!!! "Add" and "Delete" are grey out!! I can't edit
data.
> I am trying to edit data using Server Explorer under Microsoft .NET with
Trusted Connection. It works!!!
> Help, Help!
|||I believe that you will only be able to modify data from the Open Table
function in Query Analyzer if the table has a primary key or unique
constraint or a unique index.
Steve Kass
Drew University
Happy Programmer wrote:

>I have installed SQL Server 2000 with option "Client Tools Only"
>I try to edit data using SQL Query Analyzer with Trusted Connection. I click on 'Open' of right-click on table objects. A "Open Table Window" is opened as read-only!!! "Add" and "Delete" are grey out!! I can't edit data.
>I am trying to edit data using Server Explorer under Microsoft .NET with Trusted Connection. It works!!!
>Help, Help!
>
|||I've tried it. It is able to modify if the table has primary key or unique index.
But is able to edit data using Server Explorer under Microsoft .NET with Trusted Connection even it has not any key or index.
Anyway, thanks a lot~!

"Object reference not set to an instance of an object. " and connection string

Hi, I am deploying my web through a web hosting services which provides SQL database support. I got following errors whenever I try to open my webpage,which never happen when I run my web on the local machine.

I have my connection string configured in my web.config as below:

<addname="ArtHouseConnection"connectionString="Server=serveripaddress; Integrated Security=True; Database=arteh3_database;User Id=username;Password=password;"providerName="System.Data.SqlClient"/>

<addname="ASPNETDBConnectionString1"connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\ASPNETDB.MDF;Integrated Security=True;User Instance=True"providerName="System.Data.SqlClient"/>

This is the source code where error was generated:

public

staticclass ArtHouseConfiguration

{

//cache connection stringprivatereadonlystaticstring dbConnectionString;//cache data provider nameprivatereadonlystaticstring dbProviderName;

privatereadonlystaticstring siteName;

//initialize constructor propertiesstatic ArtHouseConfiguration()

{

dbConnectionString = ConfigurationManager.ConnectionStrings[

"ArtHouseConnection"].ConnectionString;

dbProviderName = ConfigurationManager.ConnectionStrings[

"ArtHouseConnection"].ProviderName;

siteName = ConfigurationManager.AppSettings["SiteName"];

}

and finally this is the error mg I got:

Object reference not set to an instance of an object.

Description:An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details:System.NullReferenceException: Object reference not set to an instance of an object.

Source Error:

Line 30: static ArtHouseConfiguration()Line 31: {Line 32: dbConnectionString = ConfigurationManager.ConnectionStrings["ArtHouseConnection"].ConnectionString;Line 33: dbProviderName = ConfigurationManager.ConnectionStrings["ArtHouseConnection"].ProviderName;Line 34:

Source File:d:\inetpub\vhosts\artehouse.org\httpdocs\App_Code\ArtHouseConfiguration.cs Line:32

Stack Trace:

[NullReferenceException: Object reference not set to an instance of an object.] ArtHouseConfiguration..cctor() in d:\inetpub\vhosts\artehouse.org\httpdocs\App_Code\ArtHouseConfiguration.cs:32[TypeInitializationException: The type initializer for 'ArtHouseConfiguration' threw an exception.] ArtHouseConfiguration.get_EnableErrorLogEmail() in d:\inetpub\vhosts\artehouse.org\httpdocs\App_Code\ArtHouseConfiguration.cs:74 Utilities.LogError(Exception ex) in d:\inetpub\vhosts\artehouse.org\httpdocs\App_Code\Utilities.cs:100 ASP.global_asax.Application_Error(Object sender, EventArgs e) in d:\inetpub\vhosts\artehouse.org\httpdocs\Global.asax:20 System.EventHandler.Invoke(Object sender, EventArgs e) +0 System.Web.HttpApplication.RaiseOnError() +182

Anyone got any ideas? thank you!

Hi genjioo,

This seems to have something to do with the web.config file.

Please check if the connections strings have been put under the configuration\connectionStrings section. Here is a typical sample

<?xml version="1.0" encoding="utf-8"?>
<configuration>
<connectionStrings>
<add name="ConnStr1" connectionString="LocalSqlServer: data source=127.0.0.1;Integrated Security=SSPI;Initial Catalog=aspnetdb"
providerName="System.Data.SqlClient" />
</connectionStrings>
</configuration>

If it is not put under this, the ConfigurationManager.ConnectionStrings will not be able to find it.

"Not associated with a trusted SQL Server connection"

Hello,
Having some trouble here with a CRM installation, and I think there is
something wrong with our SQL Server, since we got the exact same issue with
another application.
Anyhow, we got a SQL Server 2000 SP4. Right now we are running databases for
Microsoft Navision 4.0 and a .NET webshop, and it works fine. Installed a new
server the otherday (Windows Server 2003 SP1) for Microosoft CRM, and want
the CRM-databases on our current SQL Server.
During installation we get the following error:
=====================
Microsoft CRM 3.0 Server Setup
Activating SQL Server Reporting Services failed.
Setup failed to validate specified Reporting Services Report Server
http://CRM1/ReportServer. Error: The report server cannot open a connection
to the report server database. A connection to the database is required for
all requests and processing.
=====================
I press "Ignore" just to finish the installation, and it continues. After
that, when trying to connect to http://crm1 to access the system (from the
CRM1 server), it just gives the following .NET-error:
=========================
Login failed for user '(null)'. Reason: Not associated with a trusted SQL
Server connection.
=========================
Been Googleing and testing alot of stuff, but can't find the solution. I am
not that great on SQL Server, so we got a few other people to look at it, but
it just doesn't work.
Anyone know what to do, I'm clueless...
Problem solved.
On the SQL Server, in "local security policy" --> "access this computer from
the network" was only "domain/domain users" specified. I added CRM1 (the
server), and it started to work.
"joup" wrote:

> Hello,
> Having some trouble here with a CRM installation, and I think there is
> something wrong with our SQL Server, since we got the exact same issue with
> another application.
> Anyhow, we got a SQL Server 2000 SP4. Right now we are running databases for
> Microsoft Navision 4.0 and a .NET webshop, and it works fine. Installed a new
> server the otherday (Windows Server 2003 SP1) for Microosoft CRM, and want
> the CRM-databases on our current SQL Server.
> During installation we get the following error:
> =====================
> Microsoft CRM 3.0 Server Setup
> --
> Activating SQL Server Reporting Services failed.
> Setup failed to validate specified Reporting Services Report Server
> http://CRM1/ReportServer. Error: The report server cannot open a connection
> to the report server database. A connection to the database is required for
> all requests and processing.
> =====================
> I press "Ignore" just to finish the installation, and it continues. After
> that, when trying to connect to http://crm1 to access the system (from the
> CRM1 server), it just gives the following .NET-error:
> =========================
> Login failed for user '(null)'. Reason: Not associated with a trusted SQL
> Server connection.
> =========================
> Been Googleing and testing alot of stuff, but can't find the solution. I am
> not that great on SQL Server, so we got a few other people to look at it, but
> it just doesn't work.
> Anyone know what to do, I'm clueless...

"Not associated with a trusted SQL Server connection"

Hello,
Having some trouble here with a CRM installation, and I think there is
something wrong with our SQL Server, since we got the exact same issue with
another application.
Anyhow, we got a SQL Server 2000 SP4. Right now we are running databases for
Microsoft Navision 4.0 and a .NET webshop, and it works fine. Installed a ne
w
server the otherday (Windows Server 2003 SP1) for Microosoft CRM, and want
the CRM-databases on our current SQL Server.
During installation we get the following error:
=====================
Microsoft CRM 3.0 Server Setup
--
Activating SQL Server Reporting Services failed.
Setup failed to validate specified Reporting Services Report Server
http://CRM1/ReportServer. Error: The report server cannot open a connection
to the report server database. A connection to the database is required for
all requests and processing.
=====================
I press "Ignore" just to finish the installation, and it continues. After
that, when trying to connect to http://crm1 to access the system (from the
CRM1 server), it just gives the following .NET-error:
=========================
Login failed for user '(null)'. Reason: Not associated with a trusted SQL
Server connection.
=========================
Been Googleing and testing alot of stuff, but can't find the solution. I am
not that great on SQL Server, so we got a few other people to look at it, bu
t
it just doesn't work.
Anyone know what to do, I'm clueless...Problem solved.
On the SQL Server, in "local security policy" --> "access this computer from
the network" was only "domain/domain users" specified. I added CRM1 (the
server), and it started to work.
"joup" wrote:

> Hello,
> Having some trouble here with a CRM installation, and I think there is
> something wrong with our SQL Server, since we got the exact same issue wit
h
> another application.
> Anyhow, we got a SQL Server 2000 SP4. Right now we are running databases f
or
> Microsoft Navision 4.0 and a .NET webshop, and it works fine. Installed a
new
> server the otherday (Windows Server 2003 SP1) for Microosoft CRM, and want
> the CRM-databases on our current SQL Server.
> During installation we get the following error:
> =====================
> Microsoft CRM 3.0 Server Setup
> --
> Activating SQL Server Reporting Services failed.
> Setup failed to validate specified Reporting Services Report Server
> http://CRM1/ReportServer. Error: The report server cannot open a connectio
n
> to the report server database. A connection to the database is required fo
r
> all requests and processing.
> =====================
> I press "Ignore" just to finish the installation, and it continues. After
> that, when trying to connect to http://crm1 to access the system (from the
> CRM1 server), it just gives the following .NET-error:
> =========================
> Login failed for user '(null)'. Reason: Not associated with a trusted SQL
> Server connection.
> =========================
> Been Googleing and testing alot of stuff, but can't find the solution. I a
m
> not that great on SQL Server, so we got a few other people to look at it,
but
> it just doesn't work.
> Anyone know what to do, I'm clueless...

"not a trusted connection", means what EXACTLY?

There's no explaination of this error on MS or any of the documentation that
I can find. Yes, I know some of the cases that cause it, but that's a
different issue entirely.
I'm getting this error on a new SQL Server install. All of the permissions
are copied from the older server. About 2/3rds of the machines in the office
can log in fine, but the other 1/3rd return this error. There is no obvious
difference between the machines. We use Windows Authentication for everything.
So, does this error mean "I cannot verify you with the domain controller"?
Or perhaps "your domain credentials do no allow you to log in"? Or something
else entirely? Depending on the exact nature of the error, the steps to
correct it will be very different.
This part of the error message mean that there is no trust (or the trust
cannot be confirmed) between the account thatt is logging in and the SQL
Server machine. The first part of the message is the most important. What
is the complete message that the users are getting?
Rand
This posting is provided "as is" with no warranties and confers no rights.
|||"Rand Boyd [MSFT]" wrote:

> Server machine. The first part of the message is the most important. What
> is the complete message that the users are getting?
SQLState '28000'
SQL Server Error 18452
[...] Login failed for user '(null)'. Reason: not associated with a trusted
SQL Server connection.
Thanks!
|||Are you using a .NET application?
Sasan Saidi,
MSc in CS, MCSE (NT4), IBM Certified MQ Administrator
Senior DBA
Brascan Business Services
"Maury Markowitz" wrote:

> "Rand Boyd [MSFT]" wrote:
>
> SQLState '28000'
> SQL Server Error 18452
> [...] Login failed for user '(null)'. Reason: not associated with a trusted
> SQL Server connection.
> Thanks!
>
|||"Sasan Saidi" wrote:

> Are you using a .NET application?
No. I'm simply trying to set up the DSN in the Data Sources (ODBC) control
panel.
|||Has the user logged onto the domain? Does the user account have an
associated SQL login?
Jeff
"Maury Markowitz" <MauryMarkowitz@.discussions.microsoft.com> wrote in
message news:F095B40F-78FB-4096-89CA-7E9E1F9E0580@.microsoft.com...
> "Sasan Saidi" wrote:
>
> No. I'm simply trying to set up the DSN in the Data Sources (ODBC) control
> panel.
|||My guess is that the SQL Server is setup to allow only Windows logins and you try to login using a
SQL server login.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Maury Markowitz" <MauryMarkowitz@.discussions.microsoft.com> wrote in message
news:BAD981FB-7BB8-46BB-A297-80DE6CF7B543@.microsoft.com...
> "Rand Boyd [MSFT]" wrote:
>
> SQLState '28000'
> SQL Server Error 18452
> [...] Login failed for user '(null)'. Reason: not associated with a trusted
> SQL Server connection.
> Thanks!
>

"not a trusted connection", means what EXACTLY?

There's no explaination of this error on MS or any of the documentation that
I can find. Yes, I know some of the cases that cause it, but that's a
different issue entirely.
I'm getting this error on a new SQL Server install. All of the permissions
are copied from the older server. About 2/3rds of the machines in the office
can log in fine, but the other 1/3rd return this error. There is no obvious
difference between the machines. We use Windows Authentication for everythin
g.
So, does this error mean "I cannot verify you with the domain controller"?
Or perhaps "your domain credentials do no allow you to log in"? Or something
else entirely? Depending on the exact nature of the error, the steps to
correct it will be very different.This part of the error message mean that there is no trust (or the trust
cannot be confirmed) between the account thatt is logging in and the SQL
Server machine. The first part of the message is the most important. What
is the complete message that the users are getting?
Rand
This posting is provided "as is" with no warranties and confers no rights.|||"Rand Boyd [MSFT]" wrote:

> Server machine. The first part of the message is the most important. What
> is the complete message that the users are getting?
SQLState '28000'
SQL Server Error 18452
[...] Login failed for user '(null)'. Reason: not associated with a trus
ted
SQL Server connection.
Thanks!|||Are you using a .NET application?
Sasan Saidi,
MSc in CS, MCSE (NT4), IBM Certified MQ Administrator
Senior DBA
Brascan Business Services
"Maury Markowitz" wrote:

> "Rand Boyd [MSFT]" wrote:
>
> SQLState '28000'
> SQL Server Error 18452
> [...] Login failed for user '(null)'. Reason: not associated with a tr
usted
> SQL Server connection.
> Thanks!
>|||"Sasan Saidi" wrote:

> Are you using a .NET application?
No. I'm simply trying to set up the DSN in the Data Sources (ODBC) control
panel.|||Has the user logged onto the domain? Does the user account have an
associated SQL login?
Jeff
"Maury Markowitz" <MauryMarkowitz@.discussions.microsoft.com> wrote in
message news:F095B40F-78FB-4096-89CA-7E9E1F9E0580@.microsoft.com...
> "Sasan Saidi" wrote:
>
> No. I'm simply trying to set up the DSN in the Data Sources (ODBC) control
> panel.|||My guess is that the SQL Server is setup to allow only Windows logins and yo
u try to login using a
SQL server login.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Maury Markowitz" <MauryMarkowitz@.discussions.microsoft.com> wrote in messag
e
news:BAD981FB-7BB8-46BB-A297-80DE6CF7B543@.microsoft.com...
> "Rand Boyd [MSFT]" wrote:
>
> SQLState '28000'
> SQL Server Error 18452
> [...] Login failed for user '(null)'. Reason: not associated with a tr
usted
> SQL Server connection.
> Thanks!
>

"not a trusted connection", means what EXACTLY?

There's no explaination of this error on MS or any of the documentation that
I can find. Yes, I know some of the cases that cause it, but that's a
different issue entirely.
I'm getting this error on a new SQL Server install. All of the permissions
are copied from the older server. About 2/3rds of the machines in the office
can log in fine, but the other 1/3rd return this error. There is no obvious
difference between the machines. We use Windows Authentication for everything.
So, does this error mean "I cannot verify you with the domain controller"?
Or perhaps "your domain credentials do no allow you to log in"? Or something
else entirely? Depending on the exact nature of the error, the steps to
correct it will be very different.This part of the error message mean that there is no trust (or the trust
cannot be confirmed) between the account thatt is logging in and the SQL
Server machine. The first part of the message is the most important. What
is the complete message that the users are getting?
Rand
This posting is provided "as is" with no warranties and confers no rights.|||"Rand Boyd [MSFT]" wrote:
> Server machine. The first part of the message is the most important. What
> is the complete message that the users are getting?
SQLState '28000'
SQL Server Error 18452
[...] Login failed for user '(null)'. Reason: not associated with a trusted
SQL Server connection.
Thanks!|||Are you using a .NET application?
--
Sasan Saidi,
MSc in CS, MCSE (NT4), IBM Certified MQ Administrator
Senior DBA
Brascan Business Services
"Maury Markowitz" wrote:
> "Rand Boyd [MSFT]" wrote:
> > Server machine. The first part of the message is the most important. What
> > is the complete message that the users are getting?
> SQLState '28000'
> SQL Server Error 18452
> [...] Login failed for user '(null)'. Reason: not associated with a trusted
> SQL Server connection.
> Thanks!
>|||"Sasan Saidi" wrote:
> Are you using a .NET application?
No. I'm simply trying to set up the DSN in the Data Sources (ODBC) control
panel.|||Has the user logged onto the domain? Does the user account have an
associated SQL login?
Jeff
"Maury Markowitz" <MauryMarkowitz@.discussions.microsoft.com> wrote in
message news:F095B40F-78FB-4096-89CA-7E9E1F9E0580@.microsoft.com...
> "Sasan Saidi" wrote:
> > Are you using a .NET application?
> No. I'm simply trying to set up the DSN in the Data Sources (ODBC) control
> panel.|||My guess is that the SQL Server is setup to allow only Windows logins and you try to login using a
SQL server login.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Maury Markowitz" <MauryMarkowitz@.discussions.microsoft.com> wrote in message
news:BAD981FB-7BB8-46BB-A297-80DE6CF7B543@.microsoft.com...
> "Rand Boyd [MSFT]" wrote:
> > Server machine. The first part of the message is the most important. What
> > is the complete message that the users are getting?
> SQLState '28000'
> SQL Server Error 18452
> [...] Login failed for user '(null)'. Reason: not associated with a trusted
> SQL Server connection.
> Thanks!
>

"non-trusted connection" what does it mean?

What does it mean when a users is connected but it is a "non-trusted connection". This is showing up in the log file after my users connect. How does this effect the system/user? We have been experiencing speed issues and I was wondering if this might be a possible source of the problem.

Thanks in advance.A "trusted connection" is made using Windoze authentication. A "non-trusted connection" is made using SQL authentication. That is is the only difference that I know of between the two kinds of connections.

-PatP

"Login failed for user" error

hi ppl,
I'm having trouble connecting to my database using ASP.NET
I have been getting the error below whenever i try open the connection using connection.open using vb.net

I have this error in when using plain text editor as and even using
the visual studio.nets data tools (sqlconnection,sqldataadapter tool.)
The strange thing is that i can easily preview the data in any table in northwind db using the connections i've created in the solution explorer using visual studio.net.

This is the connection string created by visual studio.net (i also tried to use this connectionstring manually in code)
"initial catalog=Northwind;integrated security=SSPI;persist security info=False;workstation id=COMPI;packet size=4096"

Here is the error (same error for plain text and vs.net):

Login failed for user 'COMPI\ASPNET'
...
Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'COMPI\ASPNET'.
...
[SqlException: Login failed for user 'COMPI\ASPNET'.]
System.Data.SqlClient.ConnectionPool.GetConnection (Boolean& isInTransaction)
System.Data.SqlClient.SqlConnectionPoolManager.Get PooledConnection(SqlConnectionString options, Boolean& isInTransaction)
System.Data.SqlClient.SqlConnection.Open()
BegCh12.WebForm1.Page_Load(Object sender, EventArgs e) in C:\BegASPNet\BegCh12\WebForm1.aspx.vb:153
System.Web.UI.Control.OnLoad(EventArgs e)
System.Web.UI.Control.LoadRecursive()
System.Web.UI.Page.ProcessRequestMain()...

can someone help pls
Im using sql server 7 sp3, windows xp pro.I may have miss read this so let me restate your problem.

You have an application thaat can view and access data in the NorthWind DB but not the DB your app is written for. If that is true then it sounds like your userid "ASPNET" needs to be granted access to the db in question as well as execute or Select/Delete/Update permissions of all needed objects.|||How do i do what ur saying, is it from SQL server or using Windows XP.
I have just installed sql server and havent done any changes to permission or account (not sure how)?|||Use Enterprise Manager

Open your server, expand Security and then click on Users. right click on your UserID and select properties. Under the Database Access tab click on the Permit check box next to your database. Under the Permit in Database Role, you will want to select public, and probably db_datareader/datawrite OR you can open things up a bit and select db_owner, but I wouldn't use it for very long.

Books Online covers this very well.

"List of Values Failure" error in CR

I have designed a Crystal report from an ODBC connection. But recently I was asked to change the connection to JDBC. The data is from an SQL database. I have set the database location to JDBC from crystal report program. Everytime I preview the resuls I get the following error message.

"Prompting failed with the following error message: 'List of Values failure: fail to get values. [Cause of error: Failed to open connection. Failed to open the connection. UNKNOWN.rpt']. Error source: prompt.dll Error code: 0x8004380D."

Please help.Goto Database and Set Location and set the path
Do verify Database also

"Connection busy with another hstmt" and RIMS

Hello all,

We've got a problem which we've been trying to solve for three days now, to no avail. We're trying to set up RIMS 7.1.2 on a bunch of desktops, connecting to an SQL 6.5 database on an NT4 server. The desktops are all running Windows 98 2E.

Every time we try to launch RIMS, we get the error "Connection is busy with the results of another hstmt". This happens right after we double-click the RIMS icon, before we can even log in.

We have tried upgrading the MDAC version we were using to 2.7, but that didn't help. We even tried using older versions of the sqlsrv32.dll and odbcbcp.dll files (we found a MSKB article saying that MDAC 2.6 and 2.7 could cause this error on SQL 2000, and it specified these files). We've tried reinstalling. _Nothing_ seems to be working.

The only other thing we could think of was that maybe it has to do with the fact that the desktops have the SQL 7.0 client while the server has 6.5?

_Any_ help on this one would be greatly appreciated. We're stuck...Is it this error ? "Connection is busy with results for another hstmt" Which service pack of sql server 6.5 are you running (service pack 1 fixed an error like this) ?|||We are running 5a on the server. I don't think we're running any service packs on the clients or for the RIMS software, though...|||Is the application using both sql servers ? Have you been successful before installing this application or is this a first installation ? Is there a reason why the server is 6.5 and not 7/2000 ? Do you know what the code was written in ? This issue could be caused by software or database. Have you contacted the vendor ?|||We've never had a problem installing it before. The reason we're using 6.5 is that everytime we upgrade, we apparently have to do a major overhaul of the database. Don't know what the application is written in -- I'll see if I can find that out.

The company said to try using Named Pipes as the connection protocol instead of TCP/IP, and we did try that but it didn't fix the problem.

The boxes are all on a secure network. We're going to try connecting one of them to the main network and see if we can make it work. That should at least give us a better idea of whether it's a server problem or a problem with the desktop...

<sigh>

"Cannot find server" error message

I have a problem, my internet connection seems to terminate with time. If I
reboot my computer my connection is re-established, after the computer sits
awhile, I'll get "cannot find server" again, strange. I was hoping someone
could help me? This doesn't seem to correlate with any particular web site.
My connection is gone period. Thank you so much in advance.
Ron
I'd recommend: Microsoft.public.internetexplorer.general
It sounds like your ISP is terminating your DNS service and recycling your
IP number.
About a year ago, I experienced a similar problem. it eventually resolved
itself as the provider expanded it domain of IP numbers available. However,
I hear that some cable/DSL providers do this in order to make it difficult
for anyone publishing any type of server.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"ronellison" <ronellison@.discussions.microsoft.com> wrote in message
news:C8F81AA1-058C-4ACF-81D4-4D814919D584@.microsoft.com...
> --
> I have a problem, my internet connection seems to terminate with time. If
> I
> reboot my computer my connection is re-established, after the computer
> sits
> awhile, I'll get "cannot find server" again, strange. I was hoping someone
> could help me? This doesn't seem to correlate with any particular web
> site.
> My connection is gone period. Thank you so much in advance.
> Ron
|||I'd recommend: Microsoft.public.internetexplorer.general
It sounds like your ISP is terminating your DNS service and recycling your
IP number.
About a year ago, I experienced a similar problem. it eventually resolved
itself as the provider expanded it domain of IP numbers available. However,
I hear that some cable/DSL providers do this in order to make it difficult
for anyone publishing any type of server.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"ronellison" <ronellison@.discussions.microsoft.com> wrote in message
news:C8F81AA1-058C-4ACF-81D4-4D814919D584@.microsoft.com...
> --
> I have a problem, my internet connection seems to terminate with time. If
> I
> reboot my computer my connection is re-established, after the computer
> sits
> awhile, I'll get "cannot find server" again, strange. I was hoping someone
> could help me? This doesn't seem to correlate with any particular web
> site.
> My connection is gone period. Thank you so much in advance.
> Ron
|||Thank you so much. I've had my internet provider out to the house to look
things over (Charter Communications), they say everything looks good, signal
strength etc.
You've given me something to go on. Take care and thanks again for taking
the time to help me.
Ron
Ron
"Arnie Rowland" wrote:

> I'd recommend: Microsoft.public.internetexplorer.general
> It sounds like your ISP is terminating your DNS service and recycling your
> IP number.
> About a year ago, I experienced a similar problem. it eventually resolved
> itself as the provider expanded it domain of IP numbers available. However,
> I hear that some cable/DSL providers do this in order to make it difficult
> for anyone publishing any type of server.
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
>
> "ronellison" <ronellison@.discussions.microsoft.com> wrote in message
> news:C8F81AA1-058C-4ACF-81D4-4D814919D584@.microsoft.com...
>
>