HOW TO CONNECT SQL SERVER USING SQL AUTHENTICATION

[edshark]

---

GUYS... IF YOU HAV AN IDEA ON HOW TO CONNECT...

PLS. PM ME... KAY MAO JUD NA AKO PROBLEMA.... DLI GUSTO AMONG BOSS NGA NAA PA GIHAPON ANG WINDOWS AUTHENTICATION.... YOUR HELP IS HIGHLY APPRECIATED.. TNX..

[darkwing]

unsa man client nimo?

[digitalsuperman]

post the specs sa imo client bai...para makatubag mi nimo ug sakto....

[edshark]

unsa mn nga client inyo gi mean bro?: about sa OS ang Server: Windows 2003 ang Client both XP & 2003 maka connect ra mn mi... pro kailangan pa lagi naa access rights ang client did2 sa server... gusto nila mn gud nga bahala wla access rights ang sa Client Side pro maka connect cya tru Enterprise Manager/Network Query Analyzer... basta kabalo lng ang Client Side unsa ang UserName and Password sa SQL Server Authentication, tnx in advance......

[polie]

bro correct me sa akong pagsabot ha...you want that anybody could directly open your application and connect to SQL Server without having permissions from the SQL Server?
I don't think it would be possible because all SQL Server Clients should have the rights and permission created in the SQL Server in order for that client to be connected and use the databases for transactions and even your Windows Login should be created there in order for you to use the Windows Authentication. If they want to have this then they could just use the default username and password which is "sa" but the thing is SYS AD every user entering the Server.

[edshark]

bro correct me sa akong pagsabot ha...you want that anybody could directly open your application and connect to SQL Server without having permissions from the SQL Server?
I don't think it would be possible because all SQL Server Clients should have the rights and permission created in the SQL Server in order for that client to be connected and use the databases for transactions and even your Windows Login should be created there in order for you to use the Windows Authentication. If they want to have this then they could just use the default username and password which is "sa" but the thing is SYS AD every user entering the Server.

bro. i mean nga is it possible nga maka connect ang client tru SQL SERVER AUTHENTICATION lang nga rights i mean wala jud cya access rights sa SERVER.... pro... kabalo cya sa USERNAME and PASSWORD sa SQL Authentication.... pwede ba na cya? tnx.... coz gus2 gud sa amo boss nga dli na mag add og USERs sa SERVER..... gusto niya nga Purely SQL AUTHENTICATION LANG JUD..... wla na WINDOWS AUTHENTICATION..... tnx. in advance guys...

[darkwing]

i mean unsa ang client-side niya? VB? ASP?

[edshark]

i mean unsa ang client-side niya? VB? ASP?

BRO. VISUAL FOXPRO AMO GAMIT DIRI....

[darkwing]

bro no need to shout hehe pwede i set ang auth method sa sql server then sa connect string lang ka magdaug sa imong foxpro na program...

[edshark]

bro no need to shout hehe pwede i set ang auth method sa sql server then sa connect string lang ka magdaug sa imong foxpro na program...

sowee bro... pro gus2 mn gud nila nga sa Enterprise Manager pa daan..... inig new registration nimo, makasulod ka using your SQL Authentication Username and Password, bisan wlay ka access right sa server... basta naa lang ka rights sa SQL nga database.. pwede ba gud na bro? tnx.