Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
marko364
Starting Member
3 Posts |
 Posted - 2015-01-04 : 18:52:11
|
Hello everyone, first i want to apologize myself, i´am new with sql i dont know terminology, or anything about it. I have tried to search for different solutions on internet but could not find solution for my problem, and i dont know what to search for. I use specific software related to products from my company .It normally works on way you enter serial number and get information, but sometimes we dont get serial number but only product model or type or date or something else....so I need reverse way (by specific condition get serial number and than all information trough S/N in normal way), before it used MS access databases. In latest version it use sql server2008 r2.I have installed server 2008 (not r2) and i cant access to database, i log in with windows auth. and i get this, but cant access to real data.[URL=http://s166.photobucket.com/user/barun98989/media/upload%20novo/sql_zps3c595619.jpg.html] [/URL]i have open config file inside of software and take pass and username, i cant log inside with it. but with win auth,i have tried to change password for SA but still get same thing as on win auth. thanks in advancebest regards, marko |
|
|
sz1
Aged Yak Warrior
555 Posts |
Posted - 2015-01-05 : 05:29:38
|
| If you are connecting the Management Studio you need to have the correct permissions to be able to access the various objects. Under security is your name there? you will need to speak with the db admin to set you up.We are the creators of our own reality! |
 |
|
|
marko364
Starting Member
3 Posts |
Posted - 2015-01-05 : 16:55:50
|
| thank you for reply,company have more than 40 000 employers in more than 100 countries. It would be pretty difficult to find out who make database.Also i believe it is done by other company for us.Is there any way to go around? under security i have |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2015-01-05 : 17:02:45
|
| The user you are using has limited access. There isn't anything we can do to help you increase the access. You must find the DBA or maybe server administrator to get more access.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
marko364
Starting Member
3 Posts |
Posted - 2015-01-05 : 19:05:15
|
| i have solved problem , i can now did reverse search by customer , by product model , type .......admin can lock topic |
|
|
|
|
|
|
|
|
cant access to databases,need full access