|
Programiranje Programski jezici, tehnike, alatke... |
|
Alatke vezane za temu | Vrste prikaza |
29.10.2015, 0:40 | #1 |
Član
Član od: 20.1.2013.
Poruke: 194
Zahvalnice: 54
Zahvaljeno jedanput na jednoj poruci
|
.mdf database import
Poz,
Imam projekat radjen u visual studio 2014. Zanima me kako da importujem bazu koju imam u .mdf i .ldf ekstenziji? |
29.10.2015, 9:03 | #2 |
V.I.P. Test Play
Član od: 5.4.2006.
Lokacija: Beograd
Poruke: 14.769
Zahvalnice: 5.415
Zahvaljeno 4.097 puta na 2.672 poruka
|
Re: .mdf database import
Ako imas MS SQL serever instaliran, izguglaj malo kako da attach-ujes bazu na njega preko MS SQL Server Management Studija.
|
29.10.2015, 11:24 | #3 |
Član
Član od: 20.1.2013.
Poruke: 194
Zahvalnice: 54
Zahvaljeno jedanput na jednoj poruci
|
Re: .mdf database import
To sam vec uradio ali javlja gresku nakon pokretanja aplikacije. Treba li jos nedje da ucitam bazu?http://postimg.org/image/6l16e7m5j/
|
29.10.2015, 13:03 | #4 |
V.I.P. GNU/Linux
Član od: 1.11.2005.
Poruke: 11.166
Zahvalnice: 2.085
Zahvaljeno 4.923 puta na 2.859 poruka
|
Re: .mdf database import
Treba da podesiš prava pristupa SQL-u koristeći Management Studio:
1. Adding Login a) Click on the security\logins folder b) If the ASPNet user exist you can skip this section c) Right click login folder and choose "New Login" d) Click the "Search" button, then the "Advance" button, and then the "Find Now". This will bring up a list of user on the computer, and select the ASPNet account e) Make sure Windows authentication is checked and click "OK" to add user 2. Adding Database User a) Click on "Databases\<YourDatabase>\Security\Users" folder b) If the ASP.Net user exist you can skip this section c) Right click the user folder and choose "New User" d) Click on the "..." button next to the Login Name, then click on the "Browse" button e) Check the ASPNet user and click "OK" button. Click the OK button on the Select Login screen, enter ASPNET as user name and this will add the user f) Under database role membership check one of the following combinations. Option #2 is more secure. Click "OK" button when done Permission Options #1 dbowner Permission Options #2 db_datareader db_datewriter db_ddladmin db_securityadmin 3. Setting Database Permissions (Only needed it Option #2 is chosen above) a) Right click on the database you attached to and choose "Properties" b) Click on "Permissions" under select a page (upper-left of screen) c) Under Explicit permission for {Database Name}, make sure that the Grant box is checked for Execute |
29.10.2015, 20:53 | #5 |
Član
Član od: 20.1.2013.
Poruke: 194
Zahvalnice: 54
Zahvaljeno jedanput na jednoj poruci
|
Re: .mdf database import
Hvala na trudu! Problem je bio jer je tcp po defoultu izgasen, upalio sam ga i sad je ok.
|
Bookmarks sajtovi |
|
|
Slične teme | ||||
tema | temu započeo | forum | Odgovora | Poslednja poruka |
How to... Java | ivan90BG | Programiranje | 324 | 25.7.2020 21:56 |
Kako otvoriti .mdf? | Mr Money | Aplikativni softver | 6 | 9.10.2009 23:19 |
Igre u .mdf i .iso formatu. Šta dalje? | XPERT | O igrama uopšte | 15 | 7.8.2009 18:01 |
Database Error | barjaktar | Web razvoj | 4 | 2.6.2008 19:52 |
MDB database u EXE | DobroslaV | Aplikativni softver | 0 | 15.12.2007 16:45 |