Connecting To SQL Server

Hi,

I have a problem in logging in to an SQL Server database engine. I can log in to the engine with Windows authentication method. The problem is, when I create a page with an SqlDataConnection control, the page can not connect to the database engine eventhough I select "Use Windows Authentication" when configuring the SqlDataConnection. What should I do?

Best regards,

Haris

This article explains how to connect to SQL Server using Windows authentication.

http://msdn2.microsoft.com/en-us/library/ms998292.aspx

|||

Is the steps in the article that you mentioned also applicable on SQL Server 2005?

|||

Hi haris101,

Yes. It is applicable on sql2005.

The problem is, when I create a page with an SqlDataConnection control, the page can not connect to the database engine eventhough I select "Use Windows Authentication" when configuring the SqlDataConnection

what is your error message when your connection fails? also, did you get the error from visual web developper or IIS?

If you are getting the error from IIS (which i thin is the most case), make sure you have granted ASPNET (if using win xp) or NETWORK SERVICE (if using win 2003 server) the proper access permission. As to how to grant permission to a specific account, you can check the link tsm gave you . thanks

Connecting to MSDE2000RelA

I was able to install MSDE into WXP and migrated my Access
databases through Windows Integrated Authentication Method.
But whenever I tried connecting to MSDE by SQL login it
gives me the following error:
Invalid username and/or password, you are using a windows
login that is not your own, or server does not exist.
Please help.
Tnx,
Jess
hi Jess,
jess.tayag@.dhl.com wrote:
> I was able to install MSDE into WXP and migrated my Access
> databases through Windows Integrated Authentication Method.
> But whenever I tried connecting to MSDE by SQL login it
> gives me the following error:
> Invalid username and/or password, you are using a windows
> login that is not your own, or server does not exist.
>
if the raised error is
"Login failed for user 'UserName'. Reason: Not associated with a trusted SQL
Server connection."
the reason is MSDE is only allowing WindowsNT trusted connections and not
SQL Server authenticated connections, and this can be solved as explained in
http://support.microsoft.com/default...b;en-us;285097 in the part
regarding the Windows registry modification, while the
"SQL Server does not exists or access denied"
message is usually related to other kind of troubles, as indicated in
http://support.microsoft.com/default...06&Product=sql
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

Connecting to a local cube using Server.Connect(strStringConnection) method of AMO

I am trying to connect to a local cube using Server.Connect(strStringConnection) method of AMO

strConnectString = "Data Source=MyPath\LocalcubeName.cub"

Server.Connect(strStringConnection)

The result:

Message"The MyPath\LocalcubeName.cub' local cube file cannot be opened."String

StackTrace"at Microsoft.AnalysisServices.LocalCubeStream..ctor(String cubeFile, MSMDLOCAL_OPEN_FLAGS settings, Int32 timeout, String password)

at Microsoft.AnalysisServices.XmlaClient.OpenLocalCubeConnection(ConnectionInfo connectionInfo)

at Microsoft.AnalysisServices.XmlaClient.Connect(ConnectionInfo connectionInfo, Boolean beginSession)"String

Is there any other way to connect to a local cube using AMO?

Thanks.

Sorry Yones but your schenario is not going to work. AMO is only supported when running against Analysis Server and not with local cube files.

Use Create Global cube state to create local cube files.
http://msdn2.microsoft.com/en-us/library/ms145581.aspx
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/anserddl.mspx

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