VS 2010 & SQL server help !

[rosharavinda]

mcn umba gawa SQL Server 2008 setup eka thiyenawa neda?
umba ohomma oya dekama thiyeddi ayeth setup eka run karala thawa instance ekak dapanko.Tikak wenas namak deepanko.mama keuwe name ekennam kisima aulak na.umbe pahasuwata.Aniwa hariyai

 

[GayanSV]

mcn umba gawa SQL Server 2008 setup eka thiyenawa neda?
umba ohomma oya dekama thiyeddi ayeth setup eka run karala thawa instance ekak dapanko.Tikak wenas namak deepanko.mama keuwe name ekennam kisima aulak na.umbe pahasuwata.Aniwa hariyai

ne.mata SQL 2008 eka download karanna wenwa
me version eka hari neda ?
http://thepiratebay.org/torrent/5856244/Visual_Studio_2008_Professional_Edition

 

[rosharavinda]

na na.oya visual studio 2008 ne.eka newei.SQL Server 2008 ekai one.

 

[kosandpol]

mcn umba gawa SQL Server 2008 setup eka thiyenawa neda?
umba ohomma oya dekama thiyeddi ayeth setup eka run karala thawa instance ekak dapanko.Tikak wenas namak deepanko.mama keuwe name ekennam kisima aulak na.umbe pahasuwata.Aniwa hariyai

SQL server එක desktop OS වලට දාන්න බෑ. Server OS එකක් ඕනෙ.
SQL express විතරයි desktop OS වල දාන්න පුලුවං

 

[GayanSV]

na na.oya visual studio 2008 ne.eka newei.SQL Server 2008 ekai one.

mala kiwwalu.eka kohenda hoyanne ?
2005 eken berida ?

 

[kosandpol]

32 bit eka install karanna be machan.compatible issue ekak enawa

එහෙනං tcp/ip වලින් connect කරන්න.

 

[GayanSV]

එහෙනං tcp/ip වලින් connect කරන්න.

machan mama okkoma uninstall karala VS 2008 and SQL server 2005 install karannada (32bit eka) ?

 

[rosharavinda]

aulak nathi wei dapan

 

[kosandpol]

machan mama okkoma uninstall karala VS 2008 and SQL server 2005 install karannada (32bit eka) ?

sql server 2005 උඹට ඕකෙ install කරන්න බෑ. install කරන්න වෙන්නෙ sql express විතරයි.
VS 2008 දානකොට sql express install වෙනවා නං ඒකට හරියන management studio එක විතරක් දාගන්න.

 

[GayanSV]

ok.thanks macham.mama download karala daala balannam.

okkotama thanks

 

[lahirukasun]

hey buddy,, just do these steps. mamath athi wenna katta kaala thiyenawa oya SW 2 daanna gihin.

mulinma umbe Control panel -> Programs wala thiyena Visual Studio & SQL related okkoma SW keli uninstall karala daanna.
oya SW 2 install kalae langadi nam System Restore 1k daanna.

umba use karanne 64bit windows ney !! Server OS 1k nemei ney. e nisa apita daanna wenne SQL Express Edition1. aeka download karaganin (ISO 1k).

eeta passe aeka mount karala install karanna patan ganin.

** mage nam install karaddi remote connection awulak awa. aeka magarinna install karana welawata witharak firewall disable karanna. ehema nethnam install karanna yaddi warning 1k dei. warning 1 pita install karoth remote connection awul wenawa. ethakota ithin install kalata passe firewall exception 1k daapan SQL walata. illan naaganna ona nethi nisa firewall 1 disable karalama installation 1 patanganna.

install karanna yanakota clustered / non-clustered kiyala option 1k awoth non-clustered thorapan.

eeta passe mae link eke thiyena steps tika follow karanna.

http://www.sqlserverclub.com/essentialguides/how-to-install-sql-server-2008-step-by-step-guide.aspx

http://www.sqlserverclub.com/essent...ql-server-2008-step-by-step-guide-part-2.aspx

oya link 2 thiyena widiyatama steps follow karanna.

warnings denawa nam ewa hadagena yanna.

SQL hariyata install karata passe VS install karanna. then MSDN library 1th install karanna.

ochcharai karanna thiyenne. VS & SQL kisi awulak nethuwa weda karanawa.

** dan Firewall 1 enable karala wedaeta bahinna.

 

[Banned]

Issue is with connecting to the database.

Check Server Name, Login and password is correct. If you haven't activated mix mode in the installation. Then sql server authentication will not be available. Try using windows authentication. If you can login then that means server name is correct.

If it is in windows authentication, then sa login will be disabled due to security reasons. To activate the sql server authentication.. try this and see.

http://aspnetx.blogspot.com/2011/06/fix-change-server-authentication-mode.html